We get an unusual error.
Our DB is a 12.2.0.1.0.
The error is: ORA-64451: Conversion of special character to escaped character failed.
I identified the line which is causing the error:
v_XMLClob := dbms_xmlgen.getXML(queryCtx);
queryCtx is a handle for a SYS_REFCURSOR which is a SQL like SELECT a, b, c, from (select * from complex query). The query however outputs a table of records.
This error comes only sometimes, not all the time.
v_XMLClob for the time when it is working fine has some thing like this:
<?xml version="1.0"?>
<ROWSET>
<ROW>
<PROPERTYKEY>NRDGTP</PROPERTYKEY>
<PROPNAME>Reading Type</PROPNAME>
<PAGEDESCR>Completion Details</PAGEDESCR>
<DOMAINKEY>RDTYPEMRD</DOMAINKEY>
<DATATYPE>C</DATATYPE>
<REQDFLG>N</REQDFLG>
<USERREADFLG>Y</USERREADFLG>
<USERWRITEFLG>Y</USERWRITEFLG>
<PROPEFFECTFLG>N</PROPEFFECTFLG>
<PROPCLOB></PROPCLOB>
<ROW_ID>AAAWpsAAFAABCzSAED</ROW_ID>
<ROWVERSION>0</ROWVERSION>
<SEQ>1</SEQ>
<PRIMARYDISPLAYFLG>Y</PRIMARYDISPLAYFLG>
<PRIMARYKEY>N</PRIMARYKEY>
</ROW>
<ROW>
<PROPERTYKEY>ID</PROPERTYKEY>
<PROPNAME>HUB Internal ID</PROPNAME>
<PAGEDESCR>General</PAGEDESCR>
<VIRTUALCOLNAME>HITransactionID</VIRTUALCOLNAME>
<DATATYPE>N</DATATYPE>
<REQDFLG>N</REQDFLG>
<USERREADFLG>Y</USERREADFLG>
<USERWRITEFLG>N</USERWRITEFLG>
<PROPEFFECTFLG>N</PROPEFFECTFLG>
<BASEVALUE>45312544</BASEVALUE>
<FINALVALUE>45312544</FINALVALUE>
<ROW_ID>AAAWpNAAFAABLeVADN</ROW_ID>
<ROWVERSION>P</ROWVERSION>
<SEQ>3</SEQ>
<PRIMARYDISPLAYFLG>Y</PRIMARYDISPLAYFLG>
<PRIMARYKEY>N</PRIMARYKEY>
</ROW>
...............
.......
.....
</ROWSET>
I isolated the SQL of the SYS_REFCURSOR and ran it separately but could not find any special character like < or > in the output.
Has anybody here encountered this problem???
What could be the issue here?