Re: How to call shell script from PL/SQL ?.

From: Mervyn at ifwdc.com <merv_at_ifwdc.com>
Date: Wed, 19 Apr 2000 22:23:48 +0100
Message-ID: <8dl8va$1v29$1_at_brimstone.medianet.ie>


From memory, you can do this 2 ways. I'm sure there are more elegant ways but...

  1. Pipe the commands to the OS if it's UNIX. This involves a C Program, available from Oracle as far as I know. you've to compile it with your kernel. I'm not over sure from there on in.
  2. use UTIL_FILE defined package (perhaps FILE_UTIL?) to write a shell script to a specific directory on your server machine. Have a cron job pick it up and run it?

Merv.

Raj <rajarulmani_at_att.com> wrote in message news:38FDF480.9D00B0B1_at_att.com...
> Hi,
> can any one tell me how to call a shell script from PL/SQL ?.
>
> Thanks,
> Raj
>
>
Received on Wed Apr 19 2000 - 23:23:48 CEST

Original text of this message