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

A copy of this was sent to kev <kevin.porter_at_fast.no> (if that email address didn't require changing) On Tue, 30 Nov 1999 15:34:52 +0000, you wrote:

>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?

2gig

>What's a bind variable?
>

a substitution parameter in a sql statement. instead of coding:

insert into t values ( 'some long string' );

you would

insert into t values ( :x );

and using a host variable to supply the really long string value. See http://osi.oracle.com/~tkyte/Misc/LargeStrings.html for more info.

>thanks,
>
>- Kev
>
>

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Nov 30 1999 - 09:39:42 CST