Re: Can you execute Unix command through PL/SQL?

From: Vic Abell <abe_at_cc.purdue.edu>
Date: Sun, 31 Dec 2000 19:53:41 +0000 (UTC)
Message-ID: <92o2s5$bcu$1_at_mozo.cc.purdue.edu>


yakub <yakub_at_erols.com> writes:

>I'm trust that someone outhere know how to execute a Unix command or an
>executible from the Unix OS through PL/SQL? I am using Oracle 8.0.5 and
>8.1.5

One way to do this is via an Oracle external procedure your PL/SQL code calls. The call goes via RPC to the TNS listener. It loads your procedure's code from your shared library, then executes it. Your code can fork() and exec() the Unix executable. Received on Sun Dec 31 2000 - 20:53:41 CET

Original text of this message