23 Mar
2014
23 Mar
'14
8:42 p.m.
I'm trying to extract XML stored in a CLOB from an oracle database using the sql module for BaseX. When I select the clob value, I get this sort of thing:
<sql:column name="MSG">oracle.sql.CLOB@49458ef3</sql:column>
I've tried casting it to XMLType (similar message) and to char (buffer size too small for the XML I'm dealing with).
Is there a way of doing this short of creating a specialized Java module for it?
Thanks, Scott