Re: debug PL/SQL??
From: Jason Burgoyne <jason.burgoyne_at_bms.com>
Date: Thu, 18 Jan 2001 09:22:16 -0500
Message-ID: <3A66FC18.367F000B_at_bms.com>
Date: Thu, 18 Jan 2001 09:22:16 -0500
Message-ID: <3A66FC18.367F000B_at_bms.com>
Here is what I do
Add DBMS.PUL_LINE comments in the code (with some OAS you need to comment out
the htp calls)
Load the package/procedure/function
(If using a devel package open the DBMS output window)
EXECUTE blah.blah;
This obviously also only works if you do not have a lot of htp calls, and have
well formed exceptions so that the program will always finish executing. This
is much easier done in SQL*plus. Let me know what utils you are using.
JB
Received on Thu Jan 18 2001 - 15:22:16 CET