Procedure and Fucntions

[amishra]

Hi,

Is there any view in oracle which tells u the current procedure running in transaction or the no of times a procedure is called.

Thanks in advance.
Amit

[gandolf989]

I don't believe that Oracle will do that for you. However if you use packages you can have one of the parameters be the name of the calling procedure. You can also have a global variable for a given procedure in a package set a value on initialization and then increment that value every time the procedure gets called. Since global variables maintain their value as long as the session is active everytime you call the procedure that variable will maintain it value until you lose your connection.

Just a few thoughts.

[slimdave]

To see what procedures are running, use the DBMS_APPLICATION_INFO package to set the MODULE and ACTION within the package procedure(s) you want to monitor.