Home » SQL & PL/SQL » SQL & PL/SQL » My trigger has run amok and I can't DROP it--Help, please
My trigger has run amok and I can't DROP it--Help, please [message #213197] Tue, 09 January 2007 14:56 Go to next message
dpgrieves
Messages: 4
Registered: January 2007
Junior Member
Hello all,

I've written a trigger that calls a Java-language stored procedure on insert into a table. Last night I went to test the trigger by inserting a row into the table (using the Oracle SQL Developer client). The client application hung, and I had to kill it using Windows Task Manager.

Today, when I try to drop the trigger, I get "SQL Error: ORA-04021: timeout occurred while waiting to lock object". Does anyone have advice on how to fix this problem?

I don't have SYS login privileges, so I can't see V$ACCESS.

Thanks in advance for any help,
Dan
Re: My trigger has run amok and I can't DROP it--Help, please [message #213229 is a reply to message #213197] Tue, 09 January 2007 20:38 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Ask your DBA to kill the job.
Previous Topic: zero divisior
Next Topic: How to pass object as parameter to procedure while calling from trigger
Goto Forum:
  


Current Time: Fri Dec 09 11:58:41 CST 2016

Total time taken to generate the page: 0.22836 seconds