Problem solve Get help with specific problems with your technologies, process and projects.

ORA-00604 and ORA-03113 errors running SQL statement

Today I received the following error-message:

*** 2004-11-02 14:26:10.632
*** SESSION ID:(76.25791) 2004-11-02 14:26:10.631
ORA-00604: error occurred at recursive SQL level 1
ORA-03113: end-of-file on communication channel Dump of memory from 0x070000002958B1C4 to 0x070000002958B5C4
70000002958B1C0          494E5345 5254202F 2A2B2041      [INSERT /*+ A]
70000002958B1D0 5050454E 44204259 50415353 5F524543  [PPEND BYPASS_REC] 70000002958B1E0 55525349 56455F43 4845434B 202A2F20  [URSIVE_CHECK */ ] ....

Could you please tell me why this SQL statement always aborts?

You don't give me much to go on, not even the SQL. The ORA-604 indicates an error with an internal Oracle table (not one of yours). The ORA-3113 error is a catchall meaning that your program could not contact the database process executing your queries. This could be a communication break (like a network failure) to the process not responding (an Oracle bug). There are numerous bugs that generate ORA-3113s. My recommendation is to run the query on the database to verify that it works. You may have a permissions problem. If the query works then focus on the connection. If the query returns large amounts of data the problem could be allocating memory on the database for the cursor. Check the alert log for a trace file. You may need to run a SQL_Trace.

Dig Deeper on Oracle Application Server

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.