Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Running OS commands from stored procedures

Re: Running OS commands from stored procedures

From: Tom Hillson <tlhillson-spamisbad_at_tasc.com>
Date: Mon, 02 Nov 1998 09:59:10 -0500
Message-ID: <363DC8BD.7DCBBE22@tasc.com>


Edward,
  Under UNIX there is a way that this can be done. Oracle Government site has a (unsupported) product called PLSQL Extender (PLEX) that allows for execution of OS commands. Go to site: http://govt.us.oracle.com for more information and download of the source. PLEX uses DBMS_PIPEs to pass information between the client and the server. The server process will take the information passed (what command to run) and will execute on the unix box.

Good Luck,

Tom Hillson

EdwardAwad_at_webtv.net wrote:

> Hello everyone, I was asked today if there was a possibility of executing
> Operating system commands from an Oracle stored procedure. I was not sure
> about the answer. I know that there is the Host command in SQLplus and Forms
> but not in a stored procedure. I would appreciate any information on that
> subject.
>
> Regards,
> --
> Edward Awad
> Oracle Developer
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Nov 02 1998 - 08:59:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US