Hi,
If you insert your string values thru' SQL query the maximum
allowable string size is 4000 chars( Oracle 8.x).
Solution :
Use oracle bind variables.(please refer Oracle documentation )
************************************************
ORA-01704 string literal too long
Cause: The string literal is longer than 4000 characters.
Action: Use a string literal of at most 4000 characters. Longer values may
only be entered using bind variables.
************************************************
hope this helps
- Lakshmenarayanan
-----Original Message-----
From: Jos� Antonio Quiles [mailto:[EMAIL PROTECTED]]
Sent: Monday, 31 July, 2000 13:13
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
