Pass-through sessions to Oracle data sources

This topics identifies some SQL considerations to be aware of before you submit SQL statements to Oracle data sources in a pass-through session.

Any DDL statement issued on an Oracle server is performed at parse time and is not subject to transaction semantics. The operation, when complete, is automatically committed by Oracle. If a rollback occurs, the DDL is not rolled back.
When you issue a SELECT statement from raw data types, use the RAWTOHEX function to receive the hexadecimal values. When you perform an INSERT into raw data types, provide the hexadecimal representation.