PL/SQl: is there any debug tool?
From: Park Espenshade <park_at_crl.com>
Date: 1996/02/01
Message-ID: <4erqth$6ss_at_crl.crl.com>#1/1
Date: 1996/02/01
Message-ID: <4erqth$6ss_at_crl.crl.com>#1/1
Hi,
Put the following line at the end of your PL/SQL package:
select ue.text,ue.line,ue.position,us.text from user_errors ue,
user_source us
where ue.line = us.line and us.name = '<PACKAGE NAME>';
Show errors will provide info, but not as much.
The code for PL/SQL is stored in the user_source table.
Park Received on Thu Feb 01 1996 - 00:00:00 CET