find which PL/SQL Procedure is running in a session (using call stack)
Hi,
I would like to know how you can see which proc is currently running in an active session.
DBMS_UTILITY.FORMAT_CALL_STACK let you view the stack for the current session, but I need to view another active session.
Example :
I call a PL/SQL Proc called PA from Oracle Forms
PA runs PB, PC and finally PD.
How can I view which proc is currently running for this session ?
I mean if PB is currently running, how can I view that PB is running ?
I can only view current statement of the "frmweb" session, which is a query, but if I have 5 procs to run, I don't want to look for this query in all procs.
I would like to know how you can see which proc is currently running in an active session.
DBMS_UTILITY.FORMAT_CALL_STACK let you view the stack for the current session, but I need to view another active session.
Example :
I call a PL/SQL Proc called PA from Oracle Forms
PA runs PB, PC and finally PD.
How can I view which proc is currently running for this session ?
I mean if PB is currently running, how can I view that PB is running ?
I can only view current statement of the "frmweb" session, which is a query, but if I have 5 procs to run, I don't want to look for this query in all procs.
0