Re: Help: How to call SQL*Plus Script from inside Forms4.5

From: <moerkd_at_my-deja.com>
Date: Fri, 10 Dec 1999 20:46:34 GMT
Message-ID: <82ror9$fhr$1@nnrp1.deja.com>

In article <385090BA.F7D5581D_at_uow.edu.au>, Geoffrey Stewart <geoffrey_stewart_at_uow.edu.au> wrote:
> Hello
>
> I am a Forms 4.5 novice, and would like to call
a SQL*Plus script
> sitting on
> a UNIX machine from inside a Forms 4.5 program.
How do I do this ????
>
> Thank You
> Geoffrey
>

Hallo Geoffrey,

I don't know how you can call a server side SQL*Plus script from your client, but why don't you take the script and put it in a
stored procedure and call that procedure from your Forms Client? If there are DDL Statements in the script it may be a little bit more difficult, but if you use the functions from dbms_sql or dbms_ddl, it should work.

DETLEV Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 10 1999 - 14:46:34 CST