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

    DBMS_SQL is the correct package to use to accomplish this, but you are correct in that it is best used for server-side code only. I believe Forms has this same functionality in the FORMS_DDL package. I would look in the on-line help for this package and see what it can do for you. Hope this helps.

Shane.

nimeshs_at_my-dejanews.com wrote in message <6t6hi0$svg$1_at_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 Thu Sep 10 1998 - 05:54:17 CEST