create procedure ORA_12081_PRC as begin execute immediate q'{ create table ora_12081_tab as select * from all_objects where last_ddl_time = to_date(sysdate, 'dd.mm.yyyy') }'; exception when others then dbms_output.put_line('sqlerrm: ' || sqlerrm); for d in 1..utl_call_stack.error_depth loop dbms_output.put_line('errormsg: ' || utl_call_stack.error_msg(d)); end loop; end; / alter session set nls_date_format = 'yyyy-mm-dd'; alter session force parallel query parallel 4; begin ORA_12081_PRC; end; / drop procedure ORA_12081_PRC;
backtrace_depth
and error_depth
in utl_call_stack
.