One way would be to use an async logging mechanism based on dbms_pipe.
The trigger would send a message to a named database pipe ,and a
separate job would read from the pipe and log the output in a
permenantly open file. Alternatively use Advanced queues in a simillar
way. Both of these will be significantly quicker/scalable than your
current trigger.
Rainer Nonk <gora_at_gmx.net> wrote in message news:<3E8145F9.6E771A0F_at_gmx.net>...
> 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
Received on Wed Mar 26 2003 - 09:22:01 CST
