Re: PL/SQL Debugging

Barbara Hiles wrote:
>
> Can anyone give me some tips for debugging pl/sql?
>
> And does a newer version of pl/sql (we're on 2.2 I think) give us more
> debugging help?
>
> Any direction here would be appreciated.
>
> Thanks - Barb.

Most often used is dbms_output. Sometimes the buffer will not flush, as in when forcing the procedure to exit. If you are running from SQL+, try "exec dbms_output.put_line('Any text here')" to flush the buffer.

More sophisticated debugging can be done using dbms_pipes, and sending debug output to another session. There is programming overhead with getting this started, but well worth the effort. If you write the pipe messages to a table in the "listener" session and commit there, they will survive a rollback in the session being debugged. This is also useful for an error log.

Newer versions of PL/SQL will support file I/O, which may be helpful. We're not there yet and I don't have the details at home.

Good Luck, Larry Johnson, Keep It Simple Engineering, Inc. Received on Sun Jan 12 1997 - 00:00:00 CET