Re: [SQL question for long data type]

2000-07-07 Thread Ashutosh Punhani
ww.klgsystel.com> -Original Message- From: A mailing list about Java Server Pages specification and reference [mailto:[EMAIL PROTECTED]]On Behalf Of Hitesh panchal Sent: Thursday, June 15, 2000 8:36 PM To: [EMAIL PROTECTED] Subject: Re: [SQL question for long data type] helen ge <[EMA

Re: SQL question for long data type

2000-06-16 Thread Xing Guohong
ite Writer outstream = clob.getCharacterOutputStream(); OutputStream outstream = blob.getBinaryOutputStream(); xgh - Original Message - From: helen ge To: [EMAIL PROTECTED] Sent: Thursday, June 15, 2000 10:26 PM Subject: SQL question for long data type Hi, may be this is a simple question, but I stuc

Re: SQL question for long data type

2000-06-15 Thread Joe Milora
Sounds like a problem with the statement itself, not the retrieval of value. What is the actual select statement? -Original Message- From: helen ge [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 15, 2000 10:42 AM To: [EMAIL PROTECTED] Subject: Re: SQL question for long data type

Re: SQL question for long data type

2000-06-15 Thread helen ge
SQLException "ORA-00997 illegal use of Long data type" >From: Joe Milora <[EMAIL PROTECTED]> >Reply-To: A mailing list about Java Server Pages specification and > reference <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: Re: SQL question for long da

Re: SQL question for long data type

2000-06-15 Thread Joe Milora
rs.getString and (String)rs.getObject should work. What is the error you're receiving? -Original Message- From: Rob van Oostrum [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 15, 2000 9:39 AM To: [EMAIL PROTECTED] Subject: Re: SQL question for long data type are you sure the po

Re: SQL question for long data type

2000-06-15 Thread Rob van Oostrum
are you sure the pointer is not at a row that has no value for that column? > -Original Message- > I have an oracle table which has a long data type field named body. > in my java code I created a SQL and try to get that long field througn > ResultSet and print it out as a String. > > > S

Re: SQL question for long data type

2000-06-15 Thread Warrell Harries
]] Sent: 15 June 2000 15:26 To: [EMAIL PROTECTED] Subject: SQL question for long data type Hi, may be this is a simple question, but I stucked here. I have an oracle table which has a long data type field named body. in my java code I created a SQL and try to get that long field througn ResultSet and

Re: [SQL question for long data type]

2000-06-15 Thread Hitesh panchal
helen ge <[EMAIL PROTECTED]> wrote: Hi, may be this is a simple question, but I stucked here. I have an oracle table which has a long data type field named body. in my java code I created a SQL and try to get that long field througn ResultSet and print it out as a String. String body = rs.getSt

Re: SQL question for long data type

2000-06-15 Thread Haiying Qiao
http://technet.oracle.com/doc/java.815/a64685/basic4.htm#1002507 -Original Message- From: helen ge [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 15, 2000 10:26 AM To: [EMAIL PROTECTED] Subject: SQL question for long data type Hi, may be this is a simple question, but I stucked here

SQL question for long data type

2000-06-15 Thread helen ge
Hi, may be this is a simple question, but I stucked here. I have an oracle table which has a long data type field named body. in my java code I created a SQL and try to get that long field througn ResultSet and print it out as a String. String body = rs.getString("body");--- does not work. long