Re: What is debugging tool for PL/SQL?

Bobby Vukovic wrote:
>
> When having hundreds of lines in a stored procedure
> it would be much better to be able to know at which line
> there are errors insted of only seeing message
> "Warning: PACKAGE BODY xyx created with compilation errors"
>
> Does anybody knows such a tool or procedure?
>
> Thanks a lot.
>
> Bobby

After you get that warning message. At the SQL prompt, try typing in:

show errors

It should return the line # that contains the error and an error message. Keep in mind that blank lines in the procedure does not count as a line. If you want to find out what the line is precisely, you can also get the line from a data-dictionary table:

select text from user_source
where name = '<NAME OF PACKAGE>'
and type = 'PACKAGE BODY'
and line = <error line #>;

Lorinda Received on Thu Dec 05 1996 - 00:00:00 CET