Pls Help - Extract XMLTYPE data from Oracle 9i

tini · Post by **tini** » Fri Sep 04, 2009 2:31 pm

I have a problem to extract XMLTYPE data from Oracle 9i to text file, using Server job.
the length of this field is 400
I get the error said "internal error code, arguments:[], [], [], [], []'
I did go back to the old post in this form but none of the post can help me to solve this problem.
I'd tried LongVarChar, Varchar with but I got no luck.
I wonder if someone can help me please.
Thank you very much.

ray.wurlod · Post by **ray.wurlod** » Fri Sep 04, 2009 2:56 pm

What do you get as the data type when you import the table definition from Oracle?

chulett · Post by **chulett** » Fri Sep 04, 2009 3:38 pm

It's not a natively supported data type. Sometimes you can get away with casting to a varchar or longvarchar, or you may need to start using the XMLType methods built into Oracle to query it.

Some information for XMLType in 11g, check with your DBA what of that is applicable to 9i.