Re: Writing to a file from trigger
From: Jim Kennedy <kennedy-down_with_spammers_at_attbi.com>
Date: Tue, 20 May 2003 14:33:48 GMT
Message-ID: <g1rya.949534$S_4.968633_at_rwcrnsc53>
Date: Tue, 20 May 2003 14:33:48 GMT
Message-ID: <g1rya.949534$S_4.968633_at_rwcrnsc53>
You might be able to do something in Java. Look at writing a Java stored procedure. Instead of a file why not a table? then use some external tool to write to a file. Also writing to a file would not be acid. That is if the transaction was rolled back the file output would still be there. Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "fareeda" <fareeda_at_pspl.co.in> wrote in message news:c6d78d84.0305200531.3757d323_at_posting.google.com...Received on Tue May 20 2003 - 16:33:48 CEST
> What are the possible ways and the best among them to write to a file
> thru a oracle trigger?
> UTL_FILE cannot be used in our case since it requires making changes
> in init.ora file and that would need a restart. This is not possible
> in our production environemnt.
> Any help appreciated
> thanks