How to debug procedure in Oracle

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

原文：http://www.cnblogs.com/cquccy/p/3568426.html