1.create a table with two columns
CREATE TABLE t_debug_log(StepInfo VARCHAR2(100 BYTE), intime datetime)
2. in the procedure declare l_dml varchar2(32767);
if is bool
IF v THEN
l_dml := ‘insert into t_debug_log (StepInfo,intime) values( v, sysdate)‘;
execute immediate l_dml; END IF;
else
l_dml := ‘insert into t_debug_log (StepInfo,intime) values( v, sysdate)‘;
execute immediate l_dml;
so i can see which step is wrong.
How to debug procedure in Oracle,布布扣,bubuko.com
How to debug procedure in Oracle
原文：http://www.cnblogs.com/cquccy/p/3568426.html