Copy table command from stored procedure

From: Ahmad Salman Aziz <salmanaziz_at_sprynet.com>
Date: Sun, 25 Oct 1998 19:21:22 -0500
Message-ID: <710f8k$jlo$1@juliana.sprynet.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

salmanaziz_at_sprynet.com Received on Sun Oct 25 1998 - 18:21:22 CST