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>
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...
- 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.
- 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