Re: Help!! Can I use DBMS_SQL package from Forms 4.5?

From: Reid Lai <reidlai_at_hk.super.net>
Date: Fri, 11 Sep 1998 14:19:08 +0800
Message-ID: <35F8C0DC.944D052A@hk.super.net>

Why don't you use DO_SQL in Form 4.5?

nimeshs_at_my-dejanews.com wrote:

> Hi!,
>
> I work on Oracle 8.0 server on Unix and Forms 4.5 on Win 95. Can I use
> DBMS_SQL package from Forms 4.5 or can DBMS_SQL be used only in a backend
> procedure?
>
> Requirement: I have to construct a query during run time. The field names to
> be selected and the where condition are specified by the user at run time.
> The where condition may also contain IN conditions eg: state in
> ('Alaska','Texas') etc. I need to fetch the data from Oracle 8.0 based on
> this condition and write the retrieved records onto a text file. Can you
> suggest me a method to do this. Thanks in advance.
>
> Nim.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Fri Sep 11 1998 - 01:19:08 CDT