Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> LONG can't take more than 4000 chars???

LONG can't take more than 4000 chars???

From: kev <kevin.porter_at_fast.no>
Date: Tue, 30 Nov 1999 15:34:52 +0000
Message-ID: <3843EE9C.67B2466B@fast.no>


I'm having trouble entering a text article into a long datatype. I have no problems usually, but with an especially long article, I get this error:

ORA-01704: String literal too long

The oerr text is:

01704, 00000, "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.

So, my questions:

How many characters are allowed in a LONG? What's a bind variable?

thanks,

Received on Tue Nov 30 1999 - 09:34:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US