Re: logging mechanism

Again, table triggers are THE solution.
another tip: take as much as the sourcecode out of the trigger into a database-procedure (package), because triggercode is recompiled every time the trigger executes, while packages are stored in memory.

Regards,

Patrick Sinke
Cap Gemini Ernst & Young, sector Financial Services

Matthijs Rademakers <Matthijs.Rademakers_at_nos.nl> schreef in berichtnieuws 9d66ml$k78$1_at_porthos.nl.uu.net...
> 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 Mon May 07 2001 - 16:56:01 CEST