Re: Calling Copy command from strored procedure

Salman

I am sorry, but there is no direct interface between PL/SQL and external world in the Oracle 7.3 (I believe there is in Oracle8). To achieve what you want to do, you will have to either use user escapes or try to use PL/SQL and access the table using database link, using PL/SQL to massage your data (if your other database is accessible from Oracle - you may need to throw some money on some 'gateway product' - Oracle software), or use your Powerbilder application to talk to the both databases (although I am not familiar if is it possible to connect to two databases from the Powerbilder or not) or use Pro*C (or any other pre compiler) and connect to both databases and load data..

Kresimir Fabijanic

salmanaziz_at_my-dejanews.com wrote:

> 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 Mon Nov 09 1998 - 13:26:09 CET