My Oracle Support Banner

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

Last updated on APRIL 23, 2018

Applies to:

Oracle Forms - Version to [Release 11g]
Information in this document applies to any platform.
***Checked for relevance on 20-Mar-2014***


In Forms, 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 -

- OR -


Forms crashes with the following error:

FRM-93652: The runtime process has terminated abnormally.
Contact your system administrator.


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:

3. In the menu code of the Execute Query, add the following:

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)
alert_ID ALERT;
blk_id block;
itm item;

--ANY of these three lines of code cause a crash
alert_ID := FIND_ALERT('ANY');
END tell;

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

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


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

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

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