Re: Unix Command

From: Adrian Shepherd <Adrian.Shepherd_at_BTINTERNET.COM>
Date: Wed, 29 Apr 1998 23:28:05 +0100
Message-ID: <6i8a3b$5u3$1@mendelevium.btinternet.com>

Having never tried it, what about if your PL/SQL program inserted a row into a table , where the row was an actual command, You could exit the PL/SQL program and use SQL*Plus to execute the command by using a select on the command table and the "HOST" or "!/$" command and then recall the PL/SQL program from SQL*Plus by re-entering with the exit code as a parameter to branch out within the PL/SQL code to the point where you left off ?

Maybe this is complete bullshit, I have had a hard day at the office and probably left my brain down the pub...

Colin Sutherland wrote in message <6i09te$kjn$1_at_apple.news.easynet.net>...
>Hi
>
>This can't be done from a stored procedure. Nice thought though !
>
>Regards
>
>Colin
>Christian Capone wrote in message <6htlr8$16c4$1_at_urano.inet.it>...
>>Anybodies know how to execute a Unix command from a Oralce PL/SQL
>Procedure?
>>
>>
>
>
Received on Wed Apr 29 1998 - 17:28:05 CDT