Hi All,
I have a SOAP API request returning the XMLTYPE variable. I have used - SELECT TO_CLOB(l_xmltype_variable) FROM DUAL to convert it to a CLOB for inserting into a logging table CLOB column.
Now the problem is that it suddenly stopped working with the below error -
ORA-19011: Character string buffer too small
ORA-06512:
Could anyone suggest if this is the correct way to convert XMLTYPE to CLOB or I should use some different method?