存储过程如下:
create or replace procedure Pro_Yhwlsr(TjDate in varchar2,TJMONTH varchar2,
Msg out varchar2, errno out number)
is
v_sql varchar2(1000);
v_ErrorText varchar2(200);begin
v_sql := 'insert into tbl_acctpm(BEGIN_DATE,CELLID,MSCID,FEE1,VFEE,FAVOURFEE,FEE2)
select to_date(''200302'',''yyyymm''),nvl(cell_a,''1''),mscid,sum(fee1),sum(decode(dialed_type_id,''03'',billduration*20/3,0)),sum(fee1-fee2),sum(fee2)
from zjgsm.ticket_gsm_200302
where rownum<3 group by cell_a,mscid';
execute immediate v_sql;
Msg:= 'OK';
errno:= 1;
commit;
EXCEPTION
WHEN OTHERS THEN
errno:=-1;
v_errortext:=substrb(sqlerrm,1,200);
Msg:= v_errortext;
rollback;end Pro_Yhwlsr;
其中参数为:TjDate = ‘200302’TJMONTH=‘01’,我以cell用户登录,将zjgsm用户的内容插入到tbl_acctpm中,
为什么报错:表或视图部存在?
create or replace procedure Pro_Yhwlsr(TjDate in varchar2,TJMONTH varchar2,
Msg out varchar2, errno out number)
is
v_sql varchar2(1000);
v_ErrorText varchar2(200);begin
v_sql := 'insert into tbl_acctpm(BEGIN_DATE,CELLID,MSCID,FEE1,VFEE,FAVOURFEE,FEE2)
select to_date(''200302'',''yyyymm''),nvl(cell_a,''1''),mscid,sum(fee1),sum(decode(dialed_type_id,''03'',billduration*20/3,0)),sum(fee1-fee2),sum(fee2)
from zjgsm.ticket_gsm_200302
where rownum<3 group by cell_a,mscid';
execute immediate v_sql;
Msg:= 'OK';
errno:= 1;
commit;
EXCEPTION
WHEN OTHERS THEN
errno:=-1;
v_errortext:=substrb(sqlerrm,1,200);
Msg:= v_errortext;
rollback;end Pro_Yhwlsr;
其中参数为:TjDate = ‘200302’TJMONTH=‘01’,我以cell用户登录,将zjgsm用户的内容插入到tbl_acctpm中,
为什么报错:表或视图部存在?
加上insert any table的权限,看看怎么样