Search found 2 matches

by sabeenapeter
Mon May 11, 2015 3:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Inserting or Updating Xml data into Oracle table
Replies: 4
Views: 4330

Thanks for the responses. When I tried to insert as CLOB the below error is given ODBC_Connector_15,2: ODBC function "SQLFetch" reported: SQLSTATE = HYC00: Native Error Code = 0: Msg = [IBM(DataDirect OEM)][ODBC Oracle driver]Driver does not support selecting a column of type XMLType. You ...
by sabeenapeter
Mon May 04, 2015 10:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Inserting or Updating Xml data into Oracle table
Replies: 4
Views: 4330

Inserting or Updating Xml data into Oracle table

Hi, Im trying to read XML data from Oracle XMLType column and insert into another Oracle table column of XMLType using ODBC Connector stage in datastage 8.1. During insert the below error is thrown:- ODBC_Connector: ODBC function "SQLFetch" reported: SQLSTATE = HYC00: Native Error Code = 0...