Because your SQL call is returning an object.  You must get
the string representation of the object from one of  three
ways:

1.  object.toString();
2. (String) object;
3. Use the methods of the java.SQL.DatabaseMetaData
interface for returning data as strings

-mark

-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's
Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]On
Behalf Of Amar
Das
Sent: Wednesday, January 03, 2001 3: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

Reply via email to