Hi, Thanks a lot. It is working by changing the code in village as you have said.
Regards, Jaya. -----Original Message----- From: Shin Ohkubo [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 17, 2003 5:59 AM To: 'Apache Torque Users List' Subject: RE: Problem with CLOB retreival Hi, I was facing the same problem the other day. I retrieved the result as a oraqle.sql.CLOB, and then used the getSubString method. Object o = rset.getObject(2); if (o instanceof CLOB) { CLOB clob = (CLOB) o; System.out.println("SOURCE Length: " + clob.length()); String content = clob.getSubString(1, (int) clob.length()); System.out.println("SOURCE: " + content); } hth, SO >> -----Original Message----- >> From: Jaya [mailto:[EMAIL PROTECTED] >> Sent: Tuesday, December 16, 2003 9:13 PM >> To: [EMAIL PROTECTED] >> Subject: Problem with CLOB retreival >> >> >> >> Hi, >> >> We are using Torque with Oracle 8.1.7. But we are facing >> problem with CLOB retreival. It returns null when the column >> is retrieved as a string. We tried some workarounds like >> changing the data type to LONGVARBINARY in schema.xml. But >> it didn't work out. >> >> If any one knows the solution for this problem,please let me know. >> >> Thank You. >> >> Regards, >> Jaya. >> >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]