Home » SQL & PL/SQL » SQL & PL/SQL » Trigger - tracing invoker
Trigger - tracing invoker [message #191797] Fri, 08 September 2006 03:21 Go to next message
zecougar
Messages: 2
Registered: September 2006
Junior Member
We have a debugging problem - basically some rows that are not supposed to be deleted are being deleted by application code.

I have placed a trigger to stop the deletion of these rows.

However, what i would like is some way to figure out what Stored Procedure actually caused the trigger to be invoked.

Please advise

thanks
abhinav
Re: Trigger - tracing invoker [message #191808 is a reply to message #191797] Fri, 08 September 2006 03:52 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Check this soltution by Tom Kyte
Re: Trigger - tracing invoker [message #191837 is a reply to message #191808] Fri, 08 September 2006 05:30 Go to previous message
zecougar
Messages: 2
Registered: September 2006
Junior Member
cheers - Exactly what i was looking for.
Previous Topic: Displaying '&' in query
Next Topic: Exception handling
Goto Forum:
  


Current Time: Mon Dec 05 18:44:58 CST 2016

Total time taken to generate the page: 0.11554 seconds