Re: How to signal commit/rollback

The best solution that I think of is to create a procedure for COMMIT and ROLLBACK commands.

e.g.....

create procedure run_COMMIT
as
begin
< do ur part here >

commit ;
end

create procedure run_ROLLBACK
as
begin
< do ur part here >

commit ;
end

Rick Brown wrote in message <379ccd86.20076248_at_remote.news.azstarnet.com>...
>Hello all,
>
>We would like to catch when a commit or rollback occurs in an Oracle
>session in order to do some messaging and benchmarking. The
>application is a large collection of PL/SQL stored procedures and
>client routines which we don't want to rewrite to include calls before
>every commit, plus how do we catch all possible rollback-causing
>errors? Any ideas would be appreciated.
>
>Rick Brown
Received on Tue Jul 27 1999 - 21:06:43 CDT