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

I ran into a couple of problems with DBMS_SQL and 16-bit Forms 4.5 and Graphics 2.5. I do not know if the problem persists in your version. It involved a mismatch in the underlying PL/SQL versions of Developer 1.3 that did not support the parameter overloading used in the DBMS_SQL package.

I ended up making stored procedures for the DBMS_SQL procedures I would use. Since my procedures had strict data typing and single parameter definitions, I could call them from Developer. The procedures then called DBMS_SQL procedures, passing the parameters straight in and out from the original calling program.

Hope that helps.

• Ronald K. Olcott, President
• Interlude Enterprises
• interld808_at_aol.com

In article <6t6hgk$stp$1_at_nnrp1.dejanews.com>,   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
>

-----== 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 - 14:46:45 CDT