Export XML Result

[Remo Laubacher]

Hi,

I wrote a query which returns an XML result. It works fine after I added GetClobVal()

Wasn't there a message in the forum that said it shouldn't be necessary to use GetClobVal with version 6?

Anyway that's not the problem. My result contains a few positions so I should be able to export it. Unfortunatly everything I see in the text,xml file after the export is the value "CLOB" which is quite useless..

Is there a workaround for this issue?

Thanks!
Remo Laubacher

 

[Marco Kalter]

Wasn't there a message in the forum that said it shouldn't be necessary to use GetClobVal with version 6?

That's true, but apparently there are still some Oracle Net 9.2 bugs that can cause problems for some XMLTYPE instances.

Is there a workaround for this issue?

Unfortunately not. CLOB data cannot be exported from the grid in the current version.