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

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 - 00:00:00 CDT