April 6th, 2005, 09:48 AM
|
|
Contributing User
|
|
Join Date: Oct 2004
Posts: 181
Time spent in forums: 2 Days 4 h 25 m 11 sec
Reputation Power: 5
|
|
|
ORA-01704: string literal too long
I'm running a ColdFusion App that adds info to an Oracle Database. I have a user filling out a form and part of the form includes a textarea that allows an unlimited number of characters.
Unfortunately, I'm getting a "ORA-01704: string literal too long" error on upload. Through my research, I know I'm receiving that error because the textarea contains over 4000 characters, but I'm not sure how to correct this--haven't found a solution, still looking.
The textarea is uploading the content to a CLOB. I'm not sure if I have the wrong field type or if there is a set limit. I've not worked with Oracle much.
Thanks in advance!
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
