CLOB problem with sql scanner

Brought to you by: dejank, santibegue, triphop, vharcq

CLOB problem with sql scanner

Forum: Help

Creator: Anonymous

Created: 2003-10-23

Updated: 2003-10-23

Anonymous - 2003-10-23

Hi,

I currently have an Sql Scanner that queries an Oracle database and returns the results in the form of an XML document.

One of the fields contains a large amount of character data, (approximately 500 words or more) and is hence stored in the database as a CLOB.

The problem is the xml document returns the following line instead of the actual content of that particular field:

<story>[CDATA[oracle.sql.CLOB@476128]]</story>

Hence I was wondering if there was any way that I could access the actual data stored in the CLOB

Thanks for your time,

Joe.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Dejan Krsmanovic - 2003-10-23
  
  Oracle CLOB's are not supported yet in SqlScanner (Oracle requires some it's specific classes when working with CLOBS).
  You could try to implement it if you need it.. It should not be too hard...
  
  Dejan
  
  If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.