ORA-03113 error while compiling Oracle packages

Oracle 8i
Oracle 9i
Standard Edition
Hi All Recently we migrated our PLSQL code from Oracle to While compiling our packages in 9i, we are getting the ORA-03113: end-of-file on communication channel error. This happens only when we compile two particular packages. And then when we connect again immediately, and recompile the same package, it gets compiled. This is only happening for two packages, frequently. All other packages are not giving this error. Why could this be happening? Any pointers to this would really help. Thanks Bob

Answer Wiki


I have seen this error when your session times out. Check your session/user settings.


Discuss This Question: 4  Replies

Send me notifications when members answer or reply to this question.
  • Dneaud
    The problem could related to function prototypes not matching the final function definition. Do you have in your package a function/procedure for which the default parameter value is different in specifications and in body? If yes, try to remove the default clause or synchronize both definitions. regards
    0 pointsBadges:
  • Welcome
    Once I received this error with the following: - a table in an Oracle 8.1.6 database had a database trigger used to replicate the table, by updating an identical table in an Oracle 7.1.5 database. - performing updates in Oracle 8.1.6 from SQL*PLUS worked ok. - performing updates in Oracle 8.1.6 from an Oracle Forms application produced the ORA-03113 error. My solution was changing the database trigger, so that instead of updating the remote table, it activated a remote procedure passing it the record's data and letting the remote procedure update the table in its own database. I received the error at run-time only, not at compilation. No one could give a clear explanation why did it occur, but it's clear that it's related to some incompatibility between the two database versions. Maybe this info could help you. Best rgds, Iudith
    10 pointsBadges:
  • SID1411
    There might be an database link involved.
    0 pointsBadges:
  • carlosdl
    Do these packets use a database link ? The problem could be the DB Link configuration, and if so, of course this affect only the code that uses it.
    84,805 pointsBadges:

Forgot Password


Your password has been sent to:

To follow this tag...




Share this item with your network: