Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Running DOS/VB commands from within Forms

Re: Running DOS/VB commands from within Forms

From: Job <Job_at_pestilence.net>
Date: 2000/05/09
Message-ID: <3917ED52.4B38E543@pestilence.net>#1/1

Chris wrote:

> Hi,
>
> Can anyone help me, please ?
>
> Is there a way of running DOS scripts or VB scripts from within forms
> ?, ideally I'd like to do some processing in PL/SQL and then use a
> script to copy the resulting output to a remote destination .
>
> eg.
>
> Run PL/SQL
>
> Fire Script
>
> Copy ***.TXT d:\***.TXT
>
> Exit Script
>
> Exit PL/SQL
>
> Thanks in Advance
>
> Chris

use the UTL_FILE package to write the data directly to the required directory, you need to specify accessible directories in the init*.ora param file - should be okay with a local or mapped drive but I'm not sure about 'remote destination' Received on Tue May 09 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US