Home » SQL & PL/SQL » SQL & PL/SQL » What procedure was originally called (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi)
What procedure was originally called [message #355769] Mon, 27 October 2008 08:33 Go to next message
sayuri
Messages: 20
Registered: October 2006
Location: Cape Town
Junior Member
I have an Oracle pkg containing a few procedures that are calling each other under different circumstances.

Example: A user can call proc3. Proc3 then 1st calls proc1, then proc2 and then does whatever is in proc3.

I want to know if anyone can tell me how to get the name of the original proc was that was executed by the user.

Thanks!
Re: What procedure was originally called [message #355771 is a reply to message #355769] Mon, 27 October 2008 08:37 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Check this link.

http://asktom.oracle.com/tkyte/who_called_me/index.html

But within a package I don't think it is possible.

Regards

Raj
Re: What procedure was originally called [message #355837 is a reply to message #355771] Mon, 27 October 2008 22:25 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi rajaram,

is it not possible when i pass the success flag to some global variable and using the displayed global variable we can know the status of execution. or whether i understood the problem in wrong path.

yours
dr.s.raghunathan
Re: What procedure was originally called [message #355899 is a reply to message #355837] Tue, 28 October 2008 06:31 Go to previous message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Well what I meant is you cannot get that information dynamically using any of the builtin packages or functions apart from instrumenting it explicitly like what you have mentioned.

Hope this explains what I have meant in my previous post.

Regards

Raj
Previous Topic: INSERT OR UPDATE
Next Topic: How to reterive the newly updated record?
Goto Forum:
  


Current Time: Thu Dec 08 18:29:38 CST 2016

Total time taken to generate the page: 0.09433 seconds