declare my_cursor cursor is
( select c.user_id
from yya1.feixin_boss_add_user a,yya1.feixin_data_ftp b,aicbs.cm_user c
where a.bill_id=b.msisdn and a.bill_id=c.bill_id and b.oper_code like '%IIC%' and c.region_code='580')
open my_cursor;
declare @lluserid number(10);
fetch next from my_cursor into @lluserid
while(@@fetch_status=0)
begin
exec aicbs.tmp_prod_deal @lluserid,90525890,1;
fetch next from my_cursor into @lluserid;
end ;
close my_cursor;
deallocate my_cursor ;总是说 第一行 is 有问题,求高手指点
( select c.user_id
from yya1.feixin_boss_add_user a,yya1.feixin_data_ftp b,aicbs.cm_user c
where a.bill_id=b.msisdn and a.bill_id=c.bill_id and b.oper_code like '%IIC%' and c.region_code='580')
open my_cursor;
declare @lluserid number(10);
fetch next from my_cursor into @lluserid
while(@@fetch_status=0)
begin
exec aicbs.tmp_prod_deal @lluserid,90525890,1;
fetch next from my_cursor into @lluserid;
end ;
close my_cursor;
deallocate my_cursor ;总是说 第一行 is 有问题,求高手指点
解决方案 »
- 在oracle存储过程中删除表中的汉字
- ORACLE trigger referencing 一些问题没有弄明白!!在线等!!!!
- OracleOraDb10g_home1iSQL*Plus 服务启动错误,急解!!!
- 请教关于数据库查询的问题
- 对引索优化问题
- oracle 存储过程 急问!!!!!!!
- minimun_balance constant real:=10.00;和 amount real;分别定义了什么类型的变量?
- WIN2000 下,ORACLE 8.1.6,可以手工启动,不能自动启动,是怎么回事啊?
- 有关行列转换,特请教达人相助!
- 请教:Oracle的同步复制技术。
- Oracle找回数据
- imp导入时问题
--->declare
cursor my_cursor is
declare定义部分放到一起,不要分几个地方定义
declare之外要放到begin end
open ...不能例外
cursor my_cursor is select c.user_id from ...;
v_lluserid number(10);
begin
open my_cursor;
loop
fetch my_cursor into v_lluserid;
exit when my_cursor%notFound;
aicbs.tmp_prod_deal(v_lluserid,90525890,1);
end loop;
end;
/