我在一个触发器中写了一个
insert into tmp select * from testblob@SALINK;
其中要从另一个数据库中SELECT一个大对象INSERT到本数据库中,表结构没问题!可是在保存这个触发器时,会报“ORA-03113: 通信通道的文件结束”
把上边那句删了就没问题了,这是什么原因?那位高手能指点一下!
insert into tmp select * from testblob@SALINK;
其中要从另一个数据库中SELECT一个大对象INSERT到本数据库中,表结构没问题!可是在保存这个触发器时,会报“ORA-03113: 通信通道的文件结束”
把上边那句删了就没问题了,这是什么原因?那位高手能指点一下!
Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8, two task, software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down. Action: If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of customer support
insert into tmp select * from testblob@SALINK;
这条语句执行没问题,可是把它放到触发器中就会报错,不知为什么?
http://www.itpub.net/showthread.php?s=26de437de73455410409f3faf50e3621&threadid=124145