Basically my program crashed yesterday after it appeared to go into an infinite loop. Now if I try and access the stored procedure in question, the program will just crash. I have tried using the console and toad... both just crash out when I try to compile the sp.
The table (that the sp uses) is also in trouble... I can not delete anything from it (crash)
When I tried to drop the table I got the error message:
ORA-00054: resource busy and acquire with NOWAIT
I can only assume that this means some transaction is still open on the table, and that this is causing all the errors. I have restarted both my test pc's but still to no avail.
Can you tell me how to end this transaction, can I not do it from the oracle server side?