Getting "ORA-19202: Error occurred in XML processing" When Saving Data in Event Assessment Tab (Doc ID 2383520.1)

Last updated on DECEMBER 31, 2024

Applies to:

Symptoms

 Getting the following errors when attempting to update the as reported causality and as determined causality in event assessment tab and trying to save the case.

the following error occurs.
Upon saving the entered data is being disappeared

-- Error
Argus Safety.COM :- Oracle error 8197 occurred.
SQL execution error, ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00222: error received from SAX callback function
ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-06512: at "SYS.DBMS_XMLSTORE", line 78
ORA-06512: at "ARGUS_APP.GSS_CASE", line 2190
ORA-06512: at line 1

SQL: begin gss_case.p_case_cea_xml(:P_CASE_ID, :P_CEA_XML); end;

Argus Safety.COM :- Oracle error 8197 occurred.
SQL execution error, ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00222: error received from SAX callback function
ORA-12899: value too large for column "ARGUS_APP"."GTT_CASE_CEA"."ACJ" (actual: 1389, maximum: 1000)
ORA-06512: at "SYS.DBMS_XMLSTORE", line 78
ORA-06512: at "ARGUS_APP.GSS_CASE", line 2190
ORA-06512: at line 1

SQL: begin gss_case.p_case_cea_xml(:P_CASE_ID, :P_CEA_XML); end;

Changes

Cause

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