Or consider using external tables in 9i. Overkill for this but its always
good to consider imaginative uses of new features - if only to shoot them
down as mad.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message
news:SXDua.539819$Zo.114006_at_sccrnsc03...
> And then you can't rollback the change in the text file. Store the data
in
> a table.
> 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.
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:vbl8veju0jh18f_at_corp.supernews.com...
> >
> > "Jonathan Wolfson" <jon3825_at_hotmail.com> wrote in message
> > news:a6c92108.0305080825.70970ec6_at_posting.google.com...
> > > Can an Oracle Trigger access a file? E.g. when I update the employees
> > > table, I want a trigger run that notes the update in a text file
> > > stored on the server.
> > >
> > > Thanks!
> > >
> > > -Jonathan
> >
> > Read up on the UTL_FILE package.
> >
> >
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
> >
> > to reply remove '-verwijderdit' from my e-mail address
> >
> >
>
>
Received on Fri May 09 2003 - 02:59:23 CDT
