ORA-03113 End-of-Communication when doing large inserts via PL/SQL
I have a Oracle9i (9.2) database running on Windows 2000. I am using a PL/SQL script to read a variable length text file and insert large number of records to the database. I get the message PL/SQL procedure completed but no records have been inserted. At the database end, I get the message 'ORA-03113 End-of-Communication'.
Would appreciate if someone could help me to start troubleshooting this problem.
expose the script, lets get a taste of whats happening.
There is possiblilty of missing communication link ( Network problem ).
You can set some parameters to alive the connection between client and server or tune the Net8 and at the OS level.
Catch me online at Yahoo: ddpatel256
If you are on Oracle 188.8.131.52 and
are trying to use dbms_metadata you may get ORA-03113. If you are using ansi joins you may get ORA-03113.If you are using trying to insert long data type converted using to_lob you may get ORA-03113.
These are my experiences. Out of which Oracle has provided me one off patch for ANSI joins and for others, I was told fixed in 10G.Search for a patch provided by Oracle depending upon the case you fit in.
Click Here to Expand Forum to Full Width