CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

 ORA-01704: string literal too long

Print topic Send  topic

Author Message
cvboucher

Posts: 191
Posted: 09/03/2008, 2:57 PM

I have a record form with an fckEditor (Oracle DB/VB.Net). The column being populated by the fckEditor is a CLOB datatype which is good for about 4 Gig. The problem is that if I enter more then 4000 characters into the fckEditor window I get the above error. I found on the Internet that when more then 4000 characters are inserted into a CLOB it must be done with a bind variable. I'm guessing the CodeCharge is creating an Insert statement with the data inline instead of using bind variables. Is there a way to make CodeCharge use bind variables?

Thanks,
Craig
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.