Home » SQL & PL/SQL » SQL & PL/SQL » error ORA-00604
error ORA-00604 [message #187489] Mon, 14 August 2006 03:58 Go to next message
steffeli
Messages: 112
Registered: July 2006
Senior Member
Hello,

I write data in a table from several procedures which are running simultaneous. Then I get this error

ERROR: ORACLE execute error: ORA-00604: error occurred at recursive SQL level 1ORA-00054: resource
       busy and acquire with NOWAIT specified.


How can I solve this issue?

Thanks
Stefan
Re: error ORA-00604 [message #187490 is a reply to message #187489] Mon, 14 August 2006 04:00 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
One of your procedures didn't commit (or rollback) transaction, while another one tried to update/delete records in the same table. It will have to wait until the first one finishes.
Re: error ORA-00604 [message #187495 is a reply to message #187490] Mon, 14 August 2006 04:21 Go to previous messageGo to next message
steffeli
Messages: 112
Registered: July 2006
Senior Member
Thanks, but how can I prevent the error message? When I get the error message, the whole procedure stops.

Thanks
Stefan
Re: error ORA-00604 [message #187501 is a reply to message #187495] Mon, 14 August 2006 04:30 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You could try to lock the table (before working on it) and if it is already locked, wait and try again later.
Previous Topic: INTO clause error
Next Topic: XMLQuery bug?
Goto Forum:
  


Current Time: Sun Dec 11 01:59:55 CST 2016

Total time taken to generate the page: 0.07088 seconds