You should use a CLOB or BLOB. You should also check out Oracle
technet...there is a very good example of loading LOBs using jdbc. The
complete syntax is there. From the technet site, look for "code samples" or
something like that and you will see a link for using jdbc to load a BLOB
CLOB.
Ellis
-----Original Message-----
From: Jos� Antonio Quiles [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 31, 2000 12:43 AM
To: [EMAIL PROTECTED]
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
