My Oracle Support Banner

ORA-24197 For AQ$_JMS_MAP_MESSAGE Prepare() Method After Installing OJVM 19.14. (Doc ID 2878321.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.14.0.0.0 and later
Information in this document applies to any platform.

Symptoms

AQJMS application failing while executing message dequeue code:

 

ORA-24197: JAVA stored procedure throws JAVA exceptions
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.AQ$_JMS_MAP_MESSAGE", line 31

 

When inspecting the AQ code, the failure is noted to happen while invoking the "prepare()" method of AQ$_JMS_MAP_MESSAGE type.

Taking below PL/SQL block sample, the failure happens within "l_dq_msgid := l_dq_message.prepare (1);" below:

 

DECLARE
...
BEGIN
l_dequeue_options.consumer_name := 'AQ_TEST_SUB';
l_dequeue_options.navigation := DBMS_AQ.FIRST_MESSAGE;
l_dequeue_options.msgid := NULL;

sys.DBMS_AQ.dequeue (queue_name => 'AQ_TEST.AQ_TEST_QUEUE',
dequeue_options => l_dequeue_options,
message_properties => l_dq_msgprop,
payload => l_dq_message,
msgid => l_dq_raw_msgid);
DBMS_OUTPUT.put_line ('Dequed message');
l_dq_msgid := l_dq_message.prepare (1);
DBMS_OUTPUT.put_line ('Prepared message: ' || l_dq_msgid);
l_dq_message.get_string(l_dq_msgid,'type',l_clob);
DBMS_OUTPUT.PUT_LINE('Got message type: ' || dbms_lob.substr(l_clob, 100,1));
END;
/

 

 

Changes

Installed OJVM 19.14.0.0.220118 JVMRU

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
Changes
Cause
Solution
References


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