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

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

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

There is a demo of DBMS_TRACE in Morgan's Library at www.psoug.org.
Alternatively you can use Locator Variables such as those demonstrated
on the Exception Handling page. Scroll down to the "Locator Variables."

--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org