Help: Running SQLPLUS script from PL/SQL

From: <salmanaziz_at_my-dejanews.com>
Date: Mon, 26 Oct 1998 19:22:11 GMT
Message-ID: <712i53$9a$1_at_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 comand 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

[Quoted] -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Oct 26 1998 - 20:22:11 CET

Original text of this message