Forms Using DBMS_AQ Crash Intermittently with FRM-93652 Error

(Doc ID 2330186.1)

Last updated on NOVEMBER 20, 2017

Applies to:

Oracle Forms - Version 11.1.2.2.0 and later
Information in this document applies to any platform.

Symptoms

Using DBMS_AQ in several forms per the instructions in the document "Integrating Advanced Queuing in Oracle Forms 11g"
http://www.oracle.com/webfolder/technetwork/tutorials/obe/forms/11g/formschataq/formschataq.htm


In each form, added an 'event' in order to receive text message and display it in a text field in the forms.

But when the messages are received, it randomly crashes the forms with an FRM-93652 error.

FRM-93652 during WHEN-EVENT-RAISED trigger

The frmweb dump files show:

Last Trigger FORM/BLOCK/FIELD: F_K_CNS_CRT.NB_CRT.NB_C_WSITE_GRD
Last Trigger: WHEN-EVENT-RAISED - (In Progress)

Last Builtin: SET_EVENT_OBJECT_PROPERTY - (Successfully Completed)

----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
siehDumpStackTrace( call kgdsdst() 000000000 ? 000000000 ?
)+104 7FFF8F12F150 ? 7FFF8F12F218 ?
7FFF8F14F170 ? 000000000 ?
siehjmpterm()+650 call siehDumpStackTrace( 000000000 ? 00294D410 ?
) 7FFF8F12F150 ? 7FFF8F12F218 ?
7FFF8F14F170 ? 000000000 ?
__restore_rt() call siehjmpterm() 00000000B ? 00294D410 ?
7FFF8F12F150 ? 7FFF8F12F218 ?
...

Cause

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 hundreds of Community platforms