RE: Host System Commands from PL/SQL blocks

2002-07-31 Thread Thomas, Kevin
I sent a mail in a while ago that explains how to set up a "polling" C Shell script that accepts Unix commands coming across a DBMS_PIPE. Essentially, the shell script sits in an infinite loop polling the DBMS_PIPE and taking commands from it, executing them, and then re-runs itself. It can be st

Re: Host System Commands from PL/SQL blocks

2002-07-30 Thread Jared . Still
One solution is to write custom code to call as an external procedure. A simpler method might be to just write a daemon that starts up prior to Oracle and is controlled through data passed via a table. The daemon tries to connect periodically, and after doing so, polls the control table on a reg

Re: Host System Commands from PL/SQL blocks

2002-07-30 Thread Babu . Nagarajan
Take a look at Doc Id 50868.1 on metalink Babu John Weatherman <[EMAIL PROTECTED]>@fatcity.com on 07/30/2002 02:56:37 PM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: OK, I checked Google and my ow

Re: Host System Commands from PL/SQL blocks

2002-07-30 Thread Igor Neyman
You have to write an external stored procedure (C, C++, Java) and call it from your PL/SQL block. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 30, 2002 3:56 PM > OK, I checked Google and