My Oracle Support Banner

Forms Crash With Error FRM-93652 After 11g Upgrade (Doc ID 1096125.1)

Last updated on FEBRUARY 14, 2023

Applies to:

Oracle Forms - Version 11.1.1.2.0 to 11.1.2.2.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

In Forms 11.1.1.2, when trying to execute the sequence Enter_query and then Execute_Query from a custom menu that has the property "share library with form" =No, and KEY-ENTQRY on the form level has a call to a procedure with any of the following built-ins

alert_ID := FIND_ALERT('ANY');
- OR -

blk_id:=FIND_BLOCK('ANY');
- OR -

itm:=find_item('ANY');

Forms crashes with the following error:

 

Steps to reproduce

1. Create a simple menu with Enter Query and Execute Query items.

2. In the menu code of the Enter Query, add the following:
BEGIN
DO_KEY('Enter_Query');
END;

3. In the menu code of the Execute Query, add the following:
BEGIN
DO_KEY('Execute_Query');
END;

4. Set the menu property: "Share Library with Form"= No

5. Create a simple form, based on any table (EMP for example).

6. Make the menu created in setp1, as the default menu of the form.

7. In the form create a simple procedure TELL
PROCEDURE tell(msg in varchar2)
IS
alert_ID ALERT;
blk_id block;
itm item;
BEGIN

--**********
--ANY of these three lines of code cause a crash
alert_ID := FIND_ALERT('ANY');
--OR
--blk_id:=FIND_BLOCK('ANY');
--OR
--itm:=find_item('ANY');
--**********
END tell;

8. On the form level create a trigger KEY-ENTQRY and add the following code:
tell('Start Key Enter Query');
enter_query;
tell('End Key Enter Query');

9. On the form level create a trigger KEY-EXEQRY and add the following code:
EXECUTE_QUERY;

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
 Steps to reproduce
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.