PLSQL Call Stack
Ananth, December 09, 2008 - 7:50 am UTC
Hi Tom,
Thnanx for the response,
could you pls tell me how to see the "call stack returned to the client"
Regards
Ananth
December 09, 2008 - 2:13 pm UTC
it is the ERROR MESSAGE.
just run it in sqlplus, you'll see it. the error message contains this information.
DBMS_TRACE
Ananth, February 25, 2009 - 6:02 am UTC
Hi,
Can you just tell me how to do retreive the more details...
SQL> DECLARE
2 V_HNCID VARCHAR2(100);
3 BEGIN
4 DBMS_TRACE.SET_PLSQL_TRACE(DBMS_TRACE.TRACE_ALL_CALLS);
5 TEST_FUNCTION();
6 DBMS_OUTPUT.PUT_LINE(DBMS_UTILITY.FORMAT_CALL_STACK);
7 DBMS_TRACE.CLEAR_PLSQL_TRACE;
8 END;
9 /
the output that i got is
----- PL/SQL Call Stack -----
object line object
handle number
name
c00000017d608810 6 anonymous block
But i need more details like wat are the calls that test_function made internally..??
i dont have dba access in that schema..?
thnX in advance
Regards
Ananth
February 25, 2009 - 7:06 am UTC
dbms_trace writes to sys.plsql_trace_events
you would need access to that to see what trace produced.
You could get what you are seeing without trace:
SQL> DECLARE
2 V_HNCID VARCHAR2(100);
3 BEGIN
6 DBMS_OUTPUT.PUT_LINE(DBMS_UTILITY.FORMAT_CALL_STACK);
8 END;
9 /
would produce the output you see already, if you want access to the trace data, you'll need access to that schema object.