My Oracle Support Banner

Function ‘ESM_UTL.GET_DOCUMENT_LIST_NOTES’ generates Inconsistent Datatype error (Doc ID 2563641.1)

Last updated on SEPTEMBER 24, 2019

Applies to:

Oracle Argus Safety - Version 8.1.2 and later
Information in this document applies to any platform.

Symptoms

Function ‘ESM_UTL.GET_DOCUMENT_LIST_NOTES’ is throwing Inconsistent Datatype error.

Error:

Case 201989808 General error while creating ICSR report. The SGML
could not be generated for parent element SAFETYREPORT and child
element DOCUMENTLIST. The following error occurred: ORA-00932:
inconsistent datatypes: expected - got CLOB. Stored Procedure:
GENERATE_SAFETYREPORT

Previously working in 7.0.7 but fails in 8.2


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


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