Ask a Question related to Coldfusion Database Access, Design and Development.
-
Savo #1
ORA 01704:...too long; Only inserting 800 chars
Hi,
I am trying to insert text into a VARCHAR2 (4000) database field in Oracle
8.1.7. We are using CF Server Version 5. The text that is being entered
contains bullets/ bolded items/ and other formats. I keep getting the
ORA-01704: string literal too long Error. I have read all the postings about
this and they all mention 2000 characters versus 4000 characters. But the text
being entered is only 850 characters, so it does not fall in this.
Help is much appreciated.
Thanks
Savo Guest
-
Inserting long strings into CLOB column
I have a chunk of text data that exceeds 4k bytes. I've created a table that has a column defined to be a CLOB. I'm using Oracle 8i and trying to... -
String Literal Too Long - (less than 4000 chars)
We have a form field where users enter in a status (free text, any characters, etc). Not in every case, but a good portion of the time, when a user... -
Always making Ints 2 chars long
Hello all, I'm trying to create a menu bar option of posts in the past 5 months. I do this by getting the month from date('m'), and then... -
Inserting a binary file into a Long Raw column
Hi Is there anybody who can give me some sample code for inserting a large binary file into a LONG RAW column? I have managed to do it if the... -
inserting into a long data type
> I don't have the access or authority to change the data type from long Unlikely. Try using SQL*Loader for this. Too bad you can't change the... -
jonwrob #2 Re: DB Errore: ORA 01704:...string literal too long
Are you using bind variables (<cfqueryparam>)? This might solve your problem.
JR
jonwrob Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
