|
| ORACLE-L [EMAIL PROTECTED] |
| cc: (bcc: Mike Hately/ETECH) |
| Subject: Re: How to execute Unix |
| Command/program within a pl/sql block. |
|
Seema Singh wrote:
Hi
How
of list |
| ORACLE-L [EMAIL PROTECTED] |
| cc: (bcc: Mike Hately/ETECH) |
| Subject: Re: How to execute Unix |
| Command/program within a pl/sql block. |
|
Seema Singh wrote:
Hi
Hi Gurus
I want to execute a Unix command/program within a pl/sql block.Let me know
how to do?
Thanks
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ:
Hi
How to execute unix command in PL/SQL ?
Thanks in advance.
-Seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
INET:
Title: RE: How to execute Unix Command/program within a pl/sql block.
HOST [your command]
-Original Message-
From: Seema Singh [SMTP:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 5:00 PM
To: Multiple recipients of list ORACLE-L
Subject: How to execute Unix Command/program within
Seema Singh wrote:
Hi
How to execute unix command in PL/SQL ?
Thanks in advance.
-Seema
You can't. The nearest you can get is to write a daemon program which
waits for commands on a (dbms) pipe, executes them (popen(),
while(fgets()) {}, pclose() in C) and feeds the output back to the
Look at external procedures. You write a C program, compile it as a shared object.
You then use Oracle's create library command to tell Oracle about it. You'll need to
setup another listener and change your tnsnames entries as well. I recommend another
listener because the program runs