Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to call shell script from PL/SQL ?.

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

From: Mervyn at ifwdc.com <merv_at_ifwdc.com>
Date: 2000/04/19
Message-ID: <8dl8va$1v29$1@brimstone.medianet.ie>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US