Home » SQL & PL/SQL » SQL & PL/SQL » HOW TO TRACK STORED PROCEDURE IN TRIGGER
HOW TO TRACK STORED PROCEDURE IN TRIGGER [message #351282] Tue, 30 September 2008 03:49 Go to next message
arjunyadav
Messages: 15
Registered: September 2008
Junior Member
Dear Friedns,

I have a procedure ,In that procedure I have a table ,on that table ,on update a trigger has been written.I want that if the table has been updated through my specific procedure then only trigger should perform some specific actions
other wise that trigger should not perfom any actions.Plesase guide me how to track procedure in the trigger.

Thanks
Arjun
Re: HOW TO TRACK STORED PROCEDURE IN TRIGGER [message #351283 is a reply to message #351282] Tue, 30 September 2008 03:53 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi,
is it not possible through grant
yours
dr.s.raghunathan
Re: HOW TO TRACK STORED PROCEDURE IN TRIGGER [message #351284 is a reply to message #351282] Tue, 30 September 2008 03:54 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Write code of your trigger in your procedure and remove
the trigger.

Regards,
Rajat
Re: HOW TO TRACK STORED PROCEDURE IN TRIGGER [message #351288 is a reply to message #351282] Tue, 30 September 2008 04:09 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Set a package header variable or system context in your procedure.
Then check to see if this alue is set in the trigger.
Re: HOW TO TRACK STORED PROCEDURE IN TRIGGER [message #351297 is a reply to message #351282] Tue, 30 September 2008 04:31 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at T. Kyte How Can I find out who called me

Regards
Michel
Previous Topic: deadlock detected
Next Topic: Need to view the number of users logged in to the database
Goto Forum:
  


Current Time: Sat Dec 10 16:39:46 CST 2016

Total time taken to generate the page: 0.12871 seconds