DSXchange

Posted: **Sun Feb 15, 2009 5:44 pm**

Hi,
I have a requirement where i have to read datatype-'XMLTYPE' in Oracle Stage in Enterprise edition.While trying to View data as 'Longvarchar' i am getting error like-
"Internal Error: (colDesc):orautils.C: 1714: getColDesc failed."
Can anyone provide inputs how to do this?

Posted: **Sun Feb 15, 2009 8:40 pm**

Welcome aboard.

IMPORT the table definition from Oracle, and use it unchanged.

Posted: **Sun Feb 15, 2009 9:43 pm**

I tried this but it's not working because of the XML type.Its giving the same error -"Internal Error: (colDesc):orautils.C: 1714: getColDesc failed." while importing table definition.

Posted: **Mon Feb 16, 2009 6:49 am**

Hi,

Try using the DRS or ODBC stage. We had some issues with Memo fields and then we used the DRS or ODBC stage to resolve it.

HTH
--Rich

DSXchange

To read XML datatype in Oracle stage

To read XML datatype in Oracle stage