Re: Setting up transaction log file for my application

Supian Zainuddin wrote:
>
> To everyone,
>
> Can I set up a transaction log file that writes all transaction done by
> my PL/SQL application. I have worked only with Ingres DB and it is
> possible to have it set up to log all transaction into a file. Can you
> do the same in Oracle.
> If yes, how do I set this up, WITHOUT asking my database administrator,
> because I never seem to get any REAL answer from them.
>
> I appreciate the help from any good samaritans.
>
> Thank you.

Sure. There is a standard package utl_file with assorted file io which can
be imbedded into PL/SQL. There is a requirement for a variable to be set
in the init<SID>.ora file to make the package accessible.

Mike Krolewski Received on Wed Dec 24 1997 - 00:00:00 CET