Forms Using DBMS_AQ Crash Intermittently with FRM-93652 Error
(Doc ID 2330186.1)
Last updated on AUGUST 07, 2024
Applies to:
Oracle Forms - Version 11.1.2.2.0 and laterInformation 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
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 |
Cause |
Solution |
References |