In comp.lang.java.databases Tammy <Tamara.Gallagher@blueshieldca.com> wrote:
> I need to retrieve a clob field from an oracle table, and display it
> on a web application page. I'm currently receiving the error
> "oracle.sql.CLOB@733122" where I'm expecting the text to display.
As I understand it, you have a oracle.sql.CLOB object. This object
doesn't have an implementation of tiString() to render its contents, so
the one inherited from Object is used. I assume however, that the object
implements java.sql.Clob (verify it yourself to be sure).
If that is the case, you can use use the method getCharacterStream() to
get a java.io.Reader to read the contents of the Clob. If the Clob doesn't
contain too much data (which is vague), you may instead want to use the
methods length() and getSubString(long, int) to get a String directly.
Oscar

Signature
Oscar Kind http://home.hccnet.nl/okind/
Java/J2EE Developer email available on website