DBMS_SQL and Forms: Version flu
Date: Mon, 24 Jan 2000 16:56:33 -0800
Message-ID: <388CF4C1.B7716934_at_csufresno.edu>
The different Oracle Server versions (7.3.3, 8.0.5, 8.1.5) combined with different Developer/Forms versions is causing me lots of frustration. Here is the problem:
I have a utility form, QA (Quick Access), which gives instant access to practically any table in any database. It uses DBMS_SQL calls to access the table you select. The fmx files are available on my website for anyone to download: http://members.aol.com/stevec5088
When I compile and run QA under Forms 4.5, the very same fmx version connects to all the server versions mentioned above and performs perfectly, and the response time is snappy.
But this same form has problems when compiled under Forms 5 or Forms 6.
First of all, neither 5 or 6 will even compile on a database older than
7.3.4 -- the DBMS_SQL calls do not compile. Second, the fmx compiled on
8.0.5 or 8.1.5 will not run when
connected to other -- the dbms_sql calls fail with problems such as
Invalid Cursor or something worse. And third, the form is noticeably
slower accessing the data in a table.
This third problem is so bad, I can press the Execute Query function key in the 6.0 session, click over to the 4.5 session, press the same key and see the display in less than a second, then click back on the 6.0 session and wait several more seconds before the display comes back.
Oracle has changed something drastically at Forms 5 and 6 in the way communications with the server behave. I am at a loss to understand why. What I would ~really~ like is some magical ALTER SESSION setting that would make the later versions work like the Forms 4.5 version, and communicate nicely with all server version levels... but this is probably way too much to hope for.
Can anyone shed some light on this?
Thanks,
Steve Cosner
Received on Tue Jan 25 2000 - 01:56:33 CET