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 -> Calling Copy command from Storee Procedure

Calling Copy command from Storee Procedure

From: <salmanaziz_at_my-dejanews.com>
Date: Thu, 29 Oct 1998 21:06:44 GMT
Message-ID: <71ald4$3gi$1@nnrp1.dejanews.com>


Hi
I want to call the copy command from PL/SQL to copy a remote table . We are running Oracle 7.3 over Unix (HP). I have a script which can be run from the Unix but the question is how to call this script from PL/SQL stored procedure. Is there a way to run SQLPLUS command from PLSQL. If not, is there any interface between PL/SQL and host operating system (Unix). I need to run
this copy script to load a local table from a remote table using PowerBuilder
application.
I will appreciate your help.
Thanks
Salman

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 29 1998 - 15:06:44 CST

Original text of this message

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