Re: Host built-in

Search for this solution at Oracle's web site. It is a good solution.

Article-ID:         <Note:14082.1>
Alias:              OLS:105688.158
Circulation:        PUBLISHED (EXTERNAL)
Folder:             PLSQL
Platform:           GENERIC  Generic issue
Topic:              ** Using RDBMS Packages **
Subject:            Dynamic SQL and System Commands Using DBMS_PIPE
Modified-Date:      09-JUN-1998 17:52:07
Document-Type:      BULLETIN


Abstract:             This document presents an implemention of dynamic SQL
                      and the HOST command from PL/SQL using the DBMS_PIPE
                      package.  Source code for the implementation is
                      provided.

Joaquin Garcia Santos wrote in message <7jqhcb$eg0$1_at_talia.mad.ttd.net>...
>Hello,
>First at all, excuse my poor english.
>I need to execute a program (I have personal oracle and developer for
>windows 95) from forms of the operative system. Well I use the command HOST
>like:
>HOST(program, NO_SCREEN);
>but my problem is that the next sentence of the program (after the host
>command) is not executed until the comand host finishes. I want that my
>program do not wait until the end of the execution of host. How can I get
>this?
>Is possible to use dbms_job? If it is possible, how?
>Thanks a lot
>
>
Received on Fri Jun 11 1999 - 14:37:13 CEST