Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Triggers and OS's
Try HOST procedure.
Best regards,
Dennis
"Karl E. Taylor" wrote:
> Hello there.
>
> Here's the issue. I need to put in place a trigger that will fire off
> after a certin table has had an insert (create trigger a after insert on
> b). Then it does some internal Oracle table stuff, some inserts,
> deletes, that kind of stuff. Then I need it to go out to the OS and
> move some files that were used to make the insert happen. Now I have
> all the other stuff I need done and working, except the OS part. I
> can't find the syntax for calling the mv command from a UNIX OS to make
> this happen.
>
> Any help would be appreciated.
>
> Thanks in advance.
>
> Post or e-mail is fine.
> --
> _________________________________________________________
> Rev. Karl E. Taylor ktaylor_at_dragon.illusions.com
>
> A.A #1143 ULC Minister
>
> Home School Educator for Computer Science
>
> Apostle of Dr. Lao
> _________________________________________________________
Received on Thu Nov 05 1998 - 18:12:12 CST