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

In article <6ta1bg$rv4$1_at_nnrp1.dejanews.com>,   stevec_at_zimmer.csufresno.edu wrote:
> In article <6t6hi0$svg$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?
>
> DBMS_SQL on an 8.0 server cannot be used from Forms 4.5 directly. Instead,
> you have to write your own server-side stored procedures (a package is best)
> to call DBMS_SQL, and pass the values via parameters back to your form. It
> appears that Oracle has done something to DBMS_SQL at Oracle 8, so Forms 4.5
> can no longer communicate with it. However, if you use Forms 5.0, it all
> should work ok. At least that is my experience using Oracle 8.0.4.
>
> Steve Cosner
> http://members.aol.com/stevec5088
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

To acheive client side dynamic sql within forms V4.5 in the scenario you described , there is a package available called EXEC_SQL which I think can be found as a PLL within ORAWIN/BIN and can be attached as a library to the module where you need to access it. There are some differences between EXEC_SQL and DBMS_SQL but I belive these to be fairly minimal when there is no need to supply the connection handle. In a previous mail someone mentioned using DO_SQL, presumable refering to SRW.DO_SQL which is available within Reports V2.5 to acheive client side dynamic sql but as far as I am aware is not available within Forms V4.5. Hope the above helps resolve your problem

regards

Gareth

-----== 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 - 14:18:57 CEST