Junkone wrote:
> HI
> I have a plsql program that spans 1000 lines. it executes successfully
> but is working wrong. As it has a few dozen conditinal statements. how
> do i cache the parsing of the program so that i can know the path the
> program took
> for eg.
> i need to know that the program moved from
> Line 1
> Line 2
> Line 3
> Jumped to Line 10
> LIne 11
> Line 12
> Jumped to Line 15
>

The DBMS_TRACE package lets you trace execution of a PL/SQL program.
This package is kind of clunky, so I prefer to use SQL Developer
(available for free from http://technet.oracle.com) to do this type of
PL/SQL debugging.

HTH,
Brian

--
================================================== =================

Brian Peasland
dba@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown