SELECT XMLSERIALIZE ( DOCUMENT COLUMN1 AS CLOB NO INDENT) col1,
XMLSERIALIZE ( DOCUMENT COLUMN2 AS CLOB NO INDENT) col2, etc....
FROM tableName
WHERE PK_ID = 100;
This select always returns 1 row.
The XMLSERIALIZE is applied on around 15+ columns.
Client executes the above statement sequentially to fetch and process all rows( around 2000).
For the first few executions, the XMLSERIALIZE returns data correctly but after it returns empty value even though the xmltype column has data init.
Could you please help what is casusing the issue here ?
ORACLE 19
Sga ASSM SIZE 12G
Large pool 3.5G
PGA AGGREGATE TARGET 3G.
If we use XMLTYPECOL1.GETCLOBVAL() Its returns data without any issue.
The IBM WTX Oracle adaptor issues this select statement in shared server mode