Re: Calling OS script from PL/SQL
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