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 |