ORA-19202 LPX-00007 - Package Call With Advanced Queuing Fails When Called From Java Since 12c Upgrade

(Doc ID 2176660.1)

Last updated on OCTOBER 24, 2017

Applies to:

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

Symptoms

Since upgrading to 12.1.0.2.13, Package Call With Advanced Queuing Fails When Called From Java based application, but works in SQL*Plus or non java application.


call inat.netexpert_job_dml_pkg.deactivate_captive_portal(1046587);


Error starting at line : 1 in command -
call inat.netexpert_job_dml_pkg.deactivate_captive_portal(1046587)
Error report -
SQL Error: ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00007: unexpected end-of-file encountered
ORA-06512: at "SYS.DBMS_AQ", line 180
ORA-06512: at "INAT.NETEXPERT_JOB_DML_PKG", line 383
ORA-06512: at "INAT.NETEXPERT_JOB_TG_AI", line 3
ORA-04088: error during execution of trigger 'INAT.NETEXPERT_JOB_TG_AI'
ORA-06512: at "INAT.NETEXPERT_JOB_DML_PKG", line 97
ORA-06512: at "INAT.NETEXPERT_JOB_DML_PKG", line 110
ORA-06512: at "INAT.NETEXPERT_JOB_DML_PKG", line 332
ORA-06512: at "INAT.NETEXPERT_JOB_DML_PKG", line 531





Changes

Upgrade to 12.1.0.2.13

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