Returning and inserting/updating XML data
- Last Updated: November 29, 2018
- 1 minute read
- DataDirect Connectors
- JDBC
- Oracle Database 6.0
- Documentation
For Oracle9i and higher, the Oracle driver supports the Oracle XMLType data type. Which JDBC data type the XMLType data type is mapped to depends on whether the JDBCBehavior property is set. If JDBCBehavior=0, the driver maps the XMLType data type to the JDBC SQLXML data type.
Note: For Oracle 12c R1, the driver supports XMLType columns with binary
storage if
SupportBinaryXML=true. For Oracle 12c R2 and
higher, the driver supports XMLType columns with binary storage by default.. Starting with
Oracle 11.2.0.2, the default XML storage type was changed from CLOB to BINARY.