Re: Access to a continuous file from within a Trigger

Rainer Nonk wrote:

> Hi ng,
>
> is it possible to write from within a Trigger to continuous logfile ?
>
> What i don't want to do is this, every time the trigger is called :
>
> fopen('directory', 'file', 'w');
> put_line(file, 'some log info');
> fclose(file);
>
> ... but how can i avoid this open / close operations ?
>
> I just want to open it once - and make some put_line() inside my
> trigger.
>
> best regards,
> rainer

Don't know if this works but, in theory, I think it should.

Put your UTL_FILE open into a package. Have a proc to open the file, have a proc to close it, and a third to append. Once opened I would expect it would stay on until closed and the trigger to use the third proc to perform the appends.

If you try it let me know. Thanks.

Daniel Morgan Received on Wed Mar 26 2003 - 18:40:42 CST