Re: Executing a shell in a PL/SQL procedure

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 12 Jun 2001 18:43:51 +0200
Message-ID: <tichi4f9ovnm81@beta-news.demon.nl>

"Matthieu DEGLIN" <mdeglin_at_partner.auchan.com> wrote in message news:9g55sr$fof$1_at_reader1.imaginet.fr...
> Hello,
>
> Does anybody know a way to execute a shell script (or executable) in a
> PL/SQL procedure ?
>
> Thanks for help.
>
>

You can't. You can access the O/S API, but that's it. In Unix you would have to write a program to use the system call to spawn a command, but doing so you still can't use the full shell.

Regards,

Sybrand Bakker, Oracle DBA Received on Tue Jun 12 2001 - 11:43:51 CDT