SQL*Forms 3.0 - a rather technical question

We have more than 600 screens that are in production using SQL*Forms 3.0 and Oracle 6 on more than a dozen different platforms (please don't ask for a specific version of SQL*Forms or Oracle - no two are quite the same!). Most of these screens rely on the trick of intentionally generating an error when the [List] key is pressed in query mode to call a custom lookup screen. This has been humming along with no problems for years, but now we are moving to Oracle 7.0 and it no longer works. It now puts up SQL*Forms "normal" (read "lame") list window! Does anyone know why? How can I "break" this so it works again!!? (Oracle Forms 4.0+ is not yet an option on some of these machines.) Is the changed behaviour due to the differences in the in the Oracle or PL/SQL versions? The versions of SQL*Forms are "close". Hmmm... Specifics follow ...

List values text:

         LOV_TEXT = <<<
         select null from MS.DUAL


         >>>

/* or */
         LOV_TEXT = <<<
         select sum('X') from MS.DUAL


         >>>

[...]
         DEFINE TRIGGER

            NAME = ON-ERROR
            TRIGGER_TYPE = V3
            TEXT = <<<
            if ERROR_CODE = 40502 then
               call_custom_lookup_screen;
            else
               message (ERROR_TYPE || '-' || to_char(ERROR_CODE) || ': '
                                   || ERROR_TEXT);
               bell;
            end if;
            >>>

         ENDDEFINE TRIGGER

Newer release (where it doesn't work):
	SQL*Forms Run Form: Release 3.0.16.12.7 - Production
	ORACLE7 Server Release 7.0.16.6.0 - Production
	PL/SQL Release 2.0.18.1.0 - Production
	Using Oracle Toolkit Version 01.00.20.03.01 (Production)
	Using PL/SQL Version 01.00.39.00.01 (Production)
	Using SQL*Menu Version 05.00.11.13.05 (Production)

Example of older release - (where it does work) - selected at random:
	ORACLE RDBMS V6.0.37.3.1, transaction processing option - Production
	PL/SQL V1.0.39.0.1 - Production
	Using Oracle Toolkit Version 01.00.20.03.01 (Production)
	Using PL/SQL Version 01.00.39.00.01 (Production)
	Using SQL*Menu Version 05.00.11.13.04 (Production)

Any help would be appreciated! Please post as e-mail is often flaky.

-Don Granaman

      default_value (NULL,'GLOBAL.SIG'); Received on Wed Jan 18 1995 - 06:43:35 CET