执行存储过程报错为:PLS-00103:出现符号"CURSOR"在需要下列之一时:language,哪位大哥请帮忙看下!!
createorreplacepackagemm_jxinvoiceinfo_pkgisproceduremm_jxinvoiceinfo_proiscursorcur_...
create or replace package mm_jxinvoiceinfo_pkg is
procedure mm_jxinvoiceinfo_pro is
cursor cur_id is --报错的聚集的位置在这
select t.id
from mm_jxinvoiceinfo_ti t
where t.status = '1'
and rownum <= 100;
begin
......
end; 展开
procedure mm_jxinvoiceinfo_pro is
cursor cur_id is --报错的聚集的位置在这
select t.id
from mm_jxinvoiceinfo_ti t
where t.status = '1'
and rownum <= 100;
begin
......
end; 展开
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询