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

From: <nimeshs_at_my-dejanews.com>
Date: 1998/09/09
Message-ID: <6t6hi0$svg$1_at_nnrp1.dejanews.com>#1/1

Hi!,

[Quoted] 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 - 00:00:00 CEST

This message: [ Message body ]
Next message: Shane and Cindy Bentz: "Re: Creating multi-page report in D2K"
Previous message: Shane and Cindy Bentz: "Re: ORACLE-SQL : Sequence Problem (Need SQL GURUS)"
Next in thread: stevec_at_zimmer.csufresno.edu: "Re: Help!! Can I use DBMS_SQL package from Forms 4.5?"
Reply: stevec_at_zimmer.csufresno.edu: "Re: Help!! Can I use DBMS_SQL package from Forms 4.5?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message