Re: Long Fields

A copy of this was sent to jandrews0919_at_my-deja.com (if that email address didn't require changing) On Thu, 16 Mar 2000 21:31:31 GMT, you wrote:

>I can insert a text value > 4000 bytes into a
>long field on one table, but a max of 4000 bytes
>on another. What simple, stupid thing am I doing
>to cause this oddity.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

Are you inserting into them differently? character string constants in SQL are limited to 4000 bytes in 8.0 and up, 2000 in 7.x. If you are doing an insert with a constant (and not a bind variable) you'll hit this.

see http://osi.oracle.com/~tkyte/Misc/LargeStrings.html

-- 
http://osi.oracle.com/~tkyte/
 
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