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