Re: Copy command form stored procedure

Hi !
an approach may be to write simple "demon" programm to listen commands via oracle pipes
that demon i ve wrote on ProC ... to execute something from under Unix , just put a message from
DBMS_PIPE(..) Maxim

Joerg Heinrich wrote:

> 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 Sun Nov 08 1998 - 03:05:43 CST