Re: logging mechanism

Hi Matthijs,

like Kay said to you. The "PRAGMA AUTONOMOUS_TRANSACTION" is the very best solution for logging error message. Some of my customer have migrated to 8.1.6 only for that feature !!!

Have a nice day
  Gerd

Hi,

>
> I am looking for a plug and play (preferably a pl/sql-package) tool, that
> allows us to log transactions into a table, without the use of 'COMMIT'.
> I do not want to use COMMIT as a transaction might have to be rolled back.
>
> I know the use of the DBMS_PIPE-package could be one of the building stones
> of a logging facility that meet the requirements. I just wonder whether
> somebody has an off the shelf solution.
>
> Thanks for your help,
>
> Matthijs Rademakers
> Oracle Developer
Received on Tue May 08 2001 - 20:21:01 CEST