请教问题,error信息为:ora-04502,ora-00604,ora-03232,ora-02063
单独运行insert into table1 select * from table2@dblink_name没有问题;
但是把这句sql放在store procedure之中后,编译procedure出错,错误信息如下:
ora-04052:error occured when looking up remote object table2@dblink_name;
ora-00604:error occured at recursive SQL level 1
ora-03232:unable to allocate an extent of 36 blocks from tablespace 3
ora-02063:preceding 2 lines from dblink_name如在存储过程中编译
select a.guid as main_id, a.subagenda, b.guid as sub_id, b.modes
from pim_agenda_web@dblink a, pim_agenda_sub_web@dblink b
where instr(';'||a.subagenda, ';'||to_char(b.guid) || ';') > 0
and b.modes is not null;
就报如上错误,请各位大哥大姐帮助分析一下
单独运行insert into table1 select * from table2@dblink_name没有问题;
但是把这句sql放在store procedure之中后,编译procedure出错,错误信息如下:
ora-04052:error occured when looking up remote object table2@dblink_name;
ora-00604:error occured at recursive SQL level 1
ora-03232:unable to allocate an extent of 36 blocks from tablespace 3
ora-02063:preceding 2 lines from dblink_name如在存储过程中编译
select a.guid as main_id, a.subagenda, b.guid as sub_id, b.modes
from pim_agenda_web@dblink a, pim_agenda_sub_web@dblink b
where instr(';'||a.subagenda, ';'||to_char(b.guid) || ';') > 0
and b.modes is not null;
就报如上错误,请各位大哥大姐帮助分析一下
新建oracle QQ 群
群号:54775466
欢迎爱好者积极者 入群一起探讨。
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 ProductionTNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
本地版本是:
11.1.0.6.0
ERROR at line 1:
ORA-04052: error occurred when looking up remote object cppim.tablemame@DB_LINK
ORA-00604: error occurred at recursive SQL level 1
ORA-06544: PL/SQL: internal error, arguments: [55916], [], [], [], [], [], [],
[]
ORA-06553: PLS-801: internal error [55916]
ORA-02063: preceding 2 lines from ORA10G