OraFAQ Forum: SQL & PL/SQL » HOW TO TRACK STORED PROCEDURE IN TRIGGER

Home » SQL & PL/SQL » SQL & PL/SQL » HOW TO TRACK STORED PROCEDURE IN TRIGGER

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

HOW TO TRACK STORED PROCEDURE IN TRIGGER [message #351282]

Tue, 30 September 2008 03:49

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

Report message to a moderator

Re: HOW TO TRACK STORED PROCEDURE IN TRIGGER [message #351283 is a reply to message #351282]

Tue, 30 September 2008 03:53

dr.s.raghunathan
Messages: 540
Registered: February 2008

Senior Member

hi,
is it not possible through grant
yours
dr.s.raghunathan

Report message to a moderator

Re: HOW TO TRACK STORED PROCEDURE IN TRIGGER [message #351284 is a reply to message #351282]

Tue, 30 September 2008 03:54

rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA

Senior Member

Write code of your trigger in your procedure and remove
the trigger.

Regards,
Rajat

Report message to a moderator

Re: HOW TO TRACK STORED PROCEDURE IN TRIGGER [message #351288 is a reply to message #351282]

Tue, 30 September 2008 04:09

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.

Report message to a moderator

Re: HOW TO TRACK STORED PROCEDURE IN TRIGGER [message #351297 is a reply to message #351282]

Tue, 30 September 2008 04:31

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Have a look at T. Kyte How Can I find out who called me

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 07 05:14:48 CST 2024