Re: Finding a PL/SQL error
From: Jim Kudebeh <jkudebeh_at_jkudebeh.seanet.com>
Date: 1995/06/30
Message-ID: <3svlp8$e4f_at_kaleka.seanet.com>#1/1
spool my_file.lis
Date: 1995/06/30
Message-ID: <3svlp8$e4f_at_kaleka.seanet.com>#1/1
Here's what I've found to be of use.
------------------- code starts here ------------------------set echo on
spool my_file.lis
{body of procedure}
select *
from user_errors
/
spool off
- code ends here ------------------------
The set echo on shows each line and the line number. The select * from user_errors shows the error and the line at which the error occured. I beleive this works for database triggers also. Hope this helps.
jkudebeh Received on Fri Jun 30 1995 - 00:00:00 CEST