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.
Thanks.
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.
If you are on Oracle 9.2.0.5 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.