Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Get the line numbers parsed
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_at_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" - UnknownReceived on Mon Aug 28 2006 - 11:59:10 CDT