Attribute

SupportBinaryXML (SBX)

Purpose

Enables the driver to support XMLType with binary storage on servers running Oracle 12c and higher.

Valid Values

0 | 1

Behavior

If set to 0 (Disabled), the driver does not support XMLType with binary storage and returns the error "This column type is not currently supported by this driver."

If set to 1 (Enabled), the driver supports XMLType with binary storage by negotiating server and client capabilities during connection time. As a result of this negotiation, decoded data associated with XMLType columns is returned in an in-line fashion without locators. This setting is supported only for Oracle 12c and higher.

Notes

  • Queries involving XMLType with binary storage and XMLType with CLOB storage are affected when Support Binary XML is enabled (SupportBinaryXML=1). When Support Binary XML is enabled, XMLType with binary storage and XMLType with CLOB storage are returned in an in-line fashion without locators. Under these circumstances, executing a Select that includes XMLType columns can degrade performance because the driver must pull all in-line data to execute the query.”

Default

0 (Disabled)

GUI Tab

Advanced tab