Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Triggers and File Access

Re: Oracle Triggers and File Access

From: Jim Kennedy <kennedy-down_with_spammers_at_attbi.com>
Date: Fri, 09 May 2003 01:59:14 GMT
Message-ID: <SXDua.539819$Zo.114006@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 Thu May 08 2003 - 20:59:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US