Re: UNIX commands from within an Oracle trigger ?

In Article<31b0b070.4078110_at_news.demon.co.uk>, <alex_at_doobrie.demon.co.uk> writes:
> Path: news.NetVision.net.il!psinntp!psinntp!psinntp!howland.reston.ans.net!newsfeed.internetmci.com!uwm.edu!chi-news.cic.net!arclight.uoregon.edu!dispatch.news.demon.net!demon!doobrie.demon.co.uk
> From: alex_at_doobrie.demon.co.uk (Alex Vida)
> Newsgroups: comp.databases.oracle
> Subject: UNIX commands from within an Oracle trigger ?
> Date: Sat, 01 Jun 1996 21:05:54 GMT
> Lines: 23
> Message-ID: <31b0b070.4078110_at_news.demon.co.uk>
> NNTP-Posting-Host: doobrie.demon.co.uk
> X-NNTP-Posting-Host: doobrie.demon.co.uk
> X-Newsreader: Forte Agent .99d/32.182
>
> I've recently come across this dilemma within Oracle 7.0 in that I
> have a trigger that I use to enforce certain database-rules pertinent
> to a system that I am working on. However I also require it to perform
> a simple (!) UNIX move command and I have never come across any method
> of doing this.
>
> I don't really have to many Oracle expert minds to ask but I'm pretty
> sure that someone (out there) must have come upon a similar problem
> and that some form of a solution to how to execute this UNIX command
> from inside of the trigger must exist ? ? ?
>
> Any suggestions welcome.
>
> - Alex Vida
> -------------------------------------------------------------------
> alex_at_doobrie.demon.co.uk | We're today's scrambled creatures,
> alex_v_at_trimco.co.uk | locked in tomorrow's double feature.
> k920846_at_kingston.ac.uk | ("We Are The Dead" - Bowie)
> ___________________________|_______________________________________
> =====================================================================
> Red mutant eyes gazed down on hunger city... (Future Legend - Bowie)
> =====================================================================
>

Hi Alex,

Try using DB Pipes.

Regards.

Asaf. Received on Thu Jun 06 1996 - 00:00:00 CEST