Re: Copy command form stored procedure

From: Joerg Heinrich <joerg.heinrich_at_medienhaus-bremen.de>
Date: 3 Nov 1998 16:14:54 GMT
Message-ID: <71na5u$2dn$1@news.gim.de>

Hi
there is no Interface between PL/SQL and host operating system to call OS commands. You have only a package to work with files ( utl_file ) and a package to display messages on console ( dbms_output ).

Sorry
Joerg

In article <710bp4$fuq$1_at_nnrp1.dejanews.com>, salmanaziz_at_my-dejanews.com says...
>
>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
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Nov 03 1998 - 10:14:54 CST