1. do not use LONG, use CLOB instead.
2. look at the examples that come with Oracle for writing CLOBs via JDBC
3. copy/paste it into your code.
Thor HW
----- Original Message -----
From: "Jos� Antonio Quiles" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 31, 2000 12:42 AM
Subject: Writing long strings in Oracle
> Hello,
> we are trying to insert a huge string in an Oracle LONG field via JDBC; we
> are using PreparedStatement.setString().
> However, when the string length is longer than 2000 characters, a JDBC
> exception is raised.
> We thought that Oracle LONG field supports any string length...
> What is the problem?
>
> Thank you in advance,
>
> Jose Antonio Quiles
> Telefonica I+D
> Madrid, Spain
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> 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
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
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
