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

From: <nimeshs_at_my-dejanews.com>
Date: Wed, 09 Sep 1998 18:30:43 GMT
Message-ID: <6t6hgk$stp$1@nnrp1.dejanews.com>

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 Wed Sep 09 1998 - 13:30:43 CDT