Forms Using DBMS_AQ Crash Intermittently with FRM-93652 Error (Doc ID 2330186.1)

Last updated on AUGUST 07, 2024

Applies to:

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

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