Originally posted by: SystemAdmin

I have a column in oracle of XML type.when i am trying to insert a XML file into it ,It is failing.When i declare the column as varchar() it is accepting the text data.But i want the xml file to be inserted into the column from WTX.Can you suggest me how i can do it?
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: repanzer

As far as I know, Oracle doesn’t have an “XML” data type. Meaning, the most you can do is set the column to varchar and import it. If it’s currently working like that, why not use it?
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

repanzer,
Oracle 10G has XMLtype as the datatype for accepting XML data.(even I learnt about it from my database team)The client wants it like that.
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: repanzer

Well, I've only ever use the database interface designer to automatically generate the type tree, maybe making minor manual adjustments, but allowing DataStage to build the definition for me.

Is that what you've done and it doesn't work?
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

Unfortunately, WTX does not currently support the Oracle "XMLType" datatype through type trees. However, you may be able to use it in a DBLookup/DBQuery. I haven't tested that scenario myself... if that still doesn't work out, please post the WTX release you are using, the detailed Oracle 10g version information and advise of the approximate size of the XML. Oracle version details are displayed before the "SQL" prompt in SQL*Plus.

Jim Hobler
Software Engineer
IBM WebSphere Transformation Extender
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender