Re: Calling OS script from PL/SQL

From: Keith Bremer <kbremer_at_lecky.demon.co.uk>
Date: 1995/04/11
Message-ID: <410442030wnr_at_lecky.demon.co.uk>#1/1


In article: <3mbd6n$qip_at_llnews.ll.mit.edu> hillson_at_ll.mit.edu (Thomas L. Hillson) writes:
> Hi,
> Has anyone been able to call an operating system script from within a
 stored
> procedure? I am trying to execute a sqlload command from within a stored
 procedure and
> could not find a command to go run the script. Any ideas?
>
Tom,

        Can't be done directly! You could put the OS command into a database pipe (see DBMS_PIPE package supplied with O7) from the procedure, then have SQL*Plus running separately to pick it up, spawn an OS process to run the command and exit. If you want to re-run this repeatedly, you'll have to have an OS script running to loop round and re-execute SQL*Plus, which waits again for next message in pipe. If you want more detail, mail me at kbremer_at_uk.oracle.com

-- 
---------------------------------------------------------------------------
| Keith Bremer                                                            |
---------------------------------------------------------------------------
Received on Tue Apr 11 1995 - 00:00:00 CEST

Original text of this message