Oracle Call Stack Viewer
This script displays the current PL/SQL call stack. It uses the DBMS_UTILITY.FORMAT_CALL_STACK function to retrieve and print the execution stack, which helps in debugging and tracing PL/SQL execution flow.
oraclepl-sqlperformance-tuningv1.0.0
0 stars0 downloads13 views0 comments
By OracleDba • Created
Code
(16 lines)12345678910111213141516
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/call_stack.sql
-- Author : Tim Hall
-- Description : Displays the current call stack.
-- Requirements : Access to DBMS_UTILITY.
-- Call Syntax : @call_stack
-- Last Modified: 15/07/2000
-- -----------------------------------------------------------------------------------
SET SERVEROUTPUT ON
DECLARE
v_stack VARCHAR2(2000);
BEGIN
v_stack := Dbms_Utility.Format_Call_Stack;
Dbms_Output.Put_Line(v_stack);
END;
/