Re: Debugging scripts

Hi

Have a look at dbms_output. For dbms_output you should do

SQL> set serveroutput on size 1000000

in sqlplus first and then in your pl/sql add lines of the format:

dbms_output.put_line('This is a trace message'); dbms_output.put_line('This is a value '||v_counter);

hth

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.