ORA-03113 End-of-Communication when doing large inserts via PL/SQL
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-03113 End-of-Communication when doing large inserts via PL/SQL

  1. #1
    Join Date
    Jul 2004
    Posts
    3

    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.

    Thanks.

  2. #2
    Join Date
    Jul 2003
    Posts
    134
    expose the script, lets get a taste of whats happening.

  3. #3
    Join Date
    Feb 2003
    Location
    INDIA
    Posts
    96
    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.
    Dilip Patel
    OCP 8i

    Catch me online at Yahoo: ddpatel256

  4. #4
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    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.
    sonofsita
    http://www.ordba.net

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width