In ADF pipeline, while I use copy data for connecting to Oracle 19c Database, i get following error:
Components Used :
Copy data source / sink uses Oracle 19c and connectivity is established through Oracle linked service with SHIR run time
While copying data from azure sql to oracle I am getting following error.
{
"errorCode": "2200",
"message": "Failure happened on 'Sink' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver]Data type for parameter 3 has changed since first SQLExecute call.,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=Microsoft.DataTransfer.ClientLibrary.Odbc.Exceptions.OdbcException,Message=ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver]Data type for parameter 3 has changed since first SQLExecute call.,Source=msora28.dll,'",
"failureType": "UserError",
"target": "Copy_26n"
}
Resolution:
While creating linked service for Oracle 19c DB, add additional connection properties:
Property name: workarounds
Value: 536870912
