Re: debug PL/SQL??

Doesn't the commit also affect any work being done in the PL/SQL being debugged?

"Steve McDaniels" <steve.mcdaniels_at_sierra.com> wrote in message news:945b86$oem$1_at_spiney.sierra.com...
> Create yourself an audit table similar to:
>
> create table app_audit
> (prog_name varchar2(..),
> posting_date date,
> app_message varchar2(..)
> :
> :
> );
>
> create a procedure (accessible to the applications) like:
> create or replace procedure audit (prog_name varchar, message varchar) is
> begin
> insert into app_audit values (prog_name, sysdate, message);
> commit;
> end;
>
> use the auditing tool:
>
> create package body my_app is
> procedure process1 is
> begin
> audit('my_app','initial entry');
> ....do a bunch of stuff
> audit('my_app','got to this point');
> ....do a bunch of stuff
> audit('my_app','finished.');
> end;
> end;
>
> While my_app is running, you can peridically
>
> select * from app_audit where prog_name = 'my_app'
> /
>
> With this, you can post status messages, errors messages, etc.
>
> Warning! This app_audit table can grow quite large if you don't remove the
> audits.
>
> "mark" <markeve_at_mediaone.net> wrote in message
> news:pp876.42759$1M.9375307_at_typhoon.ne.mediaone.net...
> > Does anyone know of a way to debug pl/sql procedures? I'm currently
 working
> > with SQL-PLUS and Centura's SQL-TALK.
> >
> > Thanks.
> >
> >
>
>
Received on Thu Jan 18 2001 - 14:08:19 CET