Oracle DataStage Connector Should Automatically Serialize XMLTYPE Columns to LONGVARBINARY Instead of Requiring Explicit getBlobVal() in Every Query

I have an oracle table with a column of type XMLTYPE.  I have a flow where, using oracle-datastage conenctor, I try to cast this xml data into LONGVARBINARY type to be used in the flow. They are receiving the following error when trying to run that flow:

7/14/2026 21:08:30 ERROR IIS-CONN-ORA-01003 <Oracle_Database_for_DataStage_1,0> The OCI function OCIStmtExecute returned status -1. Error code: 932, Error message: ORA-00932: inconsistent datatypes: expected BINARY got OPAQUE TYPE. (CC_OraStatement::executeSelect, file CC_OraStatement.cpp, line 4,212)

I got the following comment from the development team:

"XMLTYPE" content must be serialized before it can be consumed by the application (Oracle datastage connector in this case), as the connector cannot process the native "XMLTYPE" representation directly. Therefore, users must explicitly choose the desired serialized representation. If the content is to be processed as a CLOB, "getClobVal()" should be used. If it is to be processed as a BLOB, "getBlobVal()" should be used. Similarly , getStringVal() should be used to process XMLType content as String datatypes. This is the expected mechanism for retrieving "XMLTYPE" data in the required format and should not be considered a workaround. Supporting all possible "XMLTYPE" serialization and retrieval scenarios can be considered a potential enhancement.

I tried the following SQL statement in the flow, and I confirmed it worked without any errors:

select t.ID, t.XML_DATA.getBlobVal(873) from MY_XML_TABLE t

However, requiring users to create a SELECT statement with getBlobVal() each time is not very user-friendly. It would be preferable for the system to automatically apply the appropriate conversion according to the target column type.

References)

[ Oracle connector for DataStage will be error when the data is LONGVARBINARY #70553 ]
https://github.ibm.com/DataStage/tracker/issues/70553

[ [5.3.1] Oracle Datastage connector cannot convert xml data to LONGVARBINARY #355862 ]
https://github.ibm.com/wdp-gov/tracker/issues/355862