I haven't haerd of any limit in string length of sql clause.
We also use Oracle 8.1.7 and classes12.zip.
Can you send the code that generates the sql.
What is the error you get?
Murray
----- Original Message -----
From: "Kang xin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 17, 2001 11:36 PM
Subject: Oracle JDBC Bug?
> Hi,
> I use Oracle 8.1.7 as my background database, classes12.zip is it's JDBC
driver. It's a type 4 JDBC 2.0 compatible driver. It's sound good?!
> BUT, I meet a problem on execute SQL clause. When my pass a dynamic
built SQL clause (654 characters long) to Statement.executeUpdate, the
driver report the clause is wrong. When I run the clause in SQL*PLUS, it's
correct.
> So, I think the JDBC driver with a SQL clause length limitation? It's
not mantained in any Oracle document.
>
> Is there anyone has idea about my problem?
> H�m�Y�� #,��r?�Z ���ګ�ڪ- z;)��z '��W�
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
