Re: Oracle LONG datatype

Oracle's string functions (substr, trim, etc) will not work with more than 2000 characters, but longs can hold more than 2000. Alot of times people need to manipulate the contents of a long and if it contains more than 2000 characters you will have problems - and Oracle won't give you error messages (at least from PL/SQL).

Make sure you are not getting the two confused.

Joseph Simes wrote in message ...
>Hello,
>
>I am mystefied. Is there no easy way to pass large quantities of text to a
>LONG field in Oracle. I am trying to upscale a Cold Fusion application from
>NT/Microsoft Access to Solaris/Oracle and the Access database uses many
 MEMO
>fields. Oracle is telling me (along with the database administrator) that
 I
>can only write/retrieve 2000 characters to/from a LONG field at a time.
>What a pain. My db administrator has pointed me to some rather complex C
>code that will bind the data to a larger data chun (whatever that means)
 but
>his sample code is way over my head.
>
>What is the purpose of a LONG field that can hold 2 gigabytes of data if
 you
>can only write 2000 characters at a time to it. Geeze there has to be an
>easire way.
>
>Any help would be greatly appreciated,
>
>Thanks a bunch,
>
>Joe Simes
>
>Elysium Arts
>v:603-335-9373
>f:603-335-8071
>www.ElysiumArts.com
>
>
Received on Thu Mar 09 2000 - 00:00:00 CET