BEGIN
p3;
/* Trapping the exception because if I do not, LiveSQL will not
show the contents of the DBMS_OUTPUT buffer.
*/
EXCEPTION WHEN OTHERS
THEN
NULL;
END;
Call Stack from DBMS_UTILITY
-
----- PL/SQL Call Stack -----
object line frame object
handle number size name
0x17e70b8c0 8 128 procedure SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P1
0x17e70b8c0 16 24 procedure SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P1
0x23e3add08 6 24 package body SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.PKG.P
0x6308234a0 5 24 procedure SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P2
0x627a263c8 5 232 procedure SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P3
0x61538c958 2 24 anonymous block
0x966e2b040 1721 88 package body SYS.DBMS_SQL.EXECUTE
0x9ee74f068 1368 4848 package body LIVESQL.ORACLE_SQL_EXEC.RUN_BLOCK
0x9ee74f068 1462 960 package body LIVESQL.ORACLE_SQL_EXEC.RUN_SQL
0x9ee74f068 1577 464 package body LIVESQL.ORACLE_SQL_EXEC.RUN_A_STATEMENT
0x9ee74f068 1902 5008 package body LIVESQL.ORACLE_SQL_EXEC.RUN_STATEMENTS
0x9ee74f068 2019 2528 package body LIVESQL.ORACLE_SQL_EXEC.RUN_STMTS
0x9f677ec20 2320 3712 package body LIVESQL.ORACLE_SQL_SCHEMA.RUN_SAVED_SESSION
0x9e66af9d0 341 112 package body LIVESQL.ORACLE_SQL_SCHEMA_PUB.RUN_SAVED_SESSION
0x219e48568 22 1616 anonymous block
0x966e2b040 1721 88 package body SYS.DBMS_SQL.EXECUTE
0x96c91ada8 1880 936 package body APEX_050100.WWV_FLOW_DYNAMIC_EXEC.RUN_BLOCK5
0x96c91ada8 936 168 package body APEX_050100.WWV_FLOW_DYNAMIC_EXEC.EXECUTE_PLSQL_CODE
0x98cf1b230 71 256 package body APEX_050100.WWV_FLOW_PROCESS_NATIVE.PLSQL
0x98cf1b230 1132 4544 package body APEX_050100.WWV_FLOW_PROCESS_NATIVE.EXECUTE_PROCESS
0x9eea33bd0 2399 2744 package body APEX_050100.WWV_FLOW_PLUGIN.EXECUTE_PROCESS
0x9f6794bf8 200 2376 package body APEX_050100.WWV_FLOW_PROCES
-
Call Stack from UTL_CALL_STACK
-
----- PL/SQL Call Stack -------
Line Object name
-------- ----------------------
12 SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P1.NESTED_IN_P1
16 SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P1
6 SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.PKG.P
5 SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P2
5 SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P3
2 .__anonymous_block
1721 SYS.DBMS_SQL.EXECUTE
1368 LIVESQL.ORACLE_SQL_EXEC.RUN_BLOCK
1462 LIVESQL.ORACLE_SQL_EXEC.RUN_SQL
1577 LIVESQL.ORACLE_SQL_EXEC.RUN_A_STATEMENT
1902 LIVESQL.ORACLE_SQL_EXEC.RUN_STATEMENTS
2019 LIVESQL.ORACLE_SQL_EXEC.RUN_STMTS
2320 LIVESQL.ORACLE_SQL_SCHEMA.RUN_SAVED_SESSION
341 LIVESQL.ORACLE_SQL_SCHEMA_PUB.RUN_SAVED_SESSION
22 .__anonymous_block
1721 SYS.DBMS_SQL.EXECUTE
1880 APEX_050100.WWV_FLOW_DYNAMIC_EXEC.RUN_BLOCK5
936 APEX_050100.WWV_FLOW_DYNAMIC_EXEC.EXECUTE_PLSQL_CODE
71 APEX_050100.WWV_FLOW_PROCESS_NATIVE.PLSQL
1132 APEX_050100.WWV_FLOW_PROCESS_NATIVE.EXECUTE_PROCESS
2399 APEX_050100.WWV_FLOW_PLUGIN.EXECUTE_PROCESS
200 APEX_050100.WWV_FLOW_PROCESS.PERFORM_PROCESS
443 APEX_050100.WWV_FLOW_PROCESS.PERFORM
4857 APEX_050100.WWV_FLOW.SHOW.RUN_BEFORE_HEADER_CODE
4904 APEX_050100.WWV_FLOW.SHOW
173 APEX_050100.F
2 .__anonymous_block
-
Error Stack from DBMS_UTILTY
-
ORA-01403: no data found
ORA-06512: at "SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P1", line 13
ORA-06512: at "SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P1", line 16
ORA-06512: at "SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.PKG", line 6
ORA-06512: at "SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P2", line 5
Error Stack from UTL_CALL_STACK
-
ORA-01403: no data found
ORA-06512: at "SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P1", line 13
ORA-06512: at "SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P1", line 16
ORA-06512: at "SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.PKG", line 6
ORA-06512: at "SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P2", line 5
-
Backtrace from DBMS_UTILITY
-
ORA-06512: at "SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P1", line 13
ORA-06512: at "SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P1", line 16
ORA-06512: at "SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.PKG", line 6
ORA-06512: at "SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P2", line 5
ORA-06512: at "SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P3", line 5
-
Backtrace from UTL_CALL_STACK
-
1 -> SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P1 - Line 13
2 -> SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P1 - Line 16
3 -> SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.PKG - Line 6
4 -> SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P2 - Line 5
5 -> SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P3 - Line 5
-
Backtrace to: SQL_GCJKCMOGHRVJQVQBGWWOVMCLH.P1 on line 13