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

[Quoted] 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 Received on Fri Sep 11 1998 - 04:19:28 CEST