XML_OPEN -> 'ORA-19011: Character string buffer too small' with large XML VARA entries

Document ID : KB000121626
Last Modified Date : 25/02/2019
Show Technical Document Details
Issue:
Using of XML_OPEN to read content of XML VARA content returns an error, once the XML content exceed an certain size: In our example the XML content is more than 9000 characters. 
U00020331 Runtime error in object 'UC0.XML_TEST-1.SCRI', line '00004': U00003590 UCUDB - DB error: 'OCIStmtFetch', 'ERROR ', '', 'ORA-19011: Character string buffer too small'

WP traces for this object (tcp=4, db=4) show the following messages sequences:
============================
11 - 20180906/114317.284 - select * from (SELECT * FROM OVW WHERE OVW_OH_Idnr = ? AND OVW_VValue = ?) where rownum < ? 
11 - 20180906/114317.284 - UCUDB32 SLBL RET 0000 HSTMT: 0x00000001108ad0 VALUE: 0x00000000000032 ALL: 0.00089 DB: 0.00067 ODBC: 0.00003 UDB: 0.00019 
11 - 20180906/114317.285 - U00029108 UCUDB: SQL_ERROR Database handles DB-HENV: c24750 DB-HDBC: c6cf58 
11 - 20180906/114317.285 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtFetch' Return code: 'ERROR' 
11 - 20180906/114317.285 - U00003592 UCUDB - Status: '' Native error: '19011' Msg: 'ORA-19011: Character string buffer too small' 
============================
Resolution:
This is a bug that is escalated to our DEV team for correction.