Amar,
LOBs don't work like normal data types. Due to the potentially large size
of the field, locators (pointer) are returned instead. What you will need
to do is get the clob locator and read the character stream from it. For
more information (and sample code), refer to the following link.
http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/java.81
7/a83724/oralob2.htm
Hope this helps,
Anne Liu
Java Architect
======================
DataPlay, Inc.
www.dataplay.com
(Direct) 303.527.9291
(Fax) 303.581.7888
6200 Lookout Road
Boulder, CO 80301
-----Original Message-----
From: Amar Das [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 03, 2001 1:22 PM
To: [EMAIL PROTECTED]
Subject: Displaying CLOB values
The following query retruns part of DEF (clob) field when done from oracle
SQL*plus window. I did the same qyery from my jsp page and tried to get
the value. But all I get is null. Why?
Select def from table_name;
Now <%=rs.getString("DEF") %> returns null.
Thank you
Amar
====================================================================
++ Amarjyoti Das
++ email: [EMAIL PROTECTED]
++ phone: (207) 594-3048 x 30
++ fax:(207) 594-3021
++ web: www.stgeorgeconsulting.com
====================================================================
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
