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

Report message to a moderator

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: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Ask your DBA to kill the job.

Report message to a moderator

Previous Topic: zero divisior
Next Topic: How to pass object as parameter to procedure while calling from trigger
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 14 00:39:27 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.