To read XML datatype in Oracle stage

kapil.budhraja · Post by **kapil.budhraja** » 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?

ray.wurlod · Post by **ray.wurlod** » Sun Feb 15, 2009 8:40 pm

Welcome aboard.

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

kapil.budhraja · Post by **kapil.budhraja** » 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.

richdhan · Post by **richdhan** » 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