Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: 2000 character limitation problem
NB: Under Oracle 8, the limit of 2000 is increaded to 4000
In article <6m6kmk$aqg$1_at_aramis.rutgers.edu>, dcohen_at_aramis.rutgers.edu (Dawn
Myfanwy Cohen) wrote:
>keathley_at_writeme.com writes:
>
>>Any help will be greatly appreciated:
>
>>I have defined a table in my Oracle db with the following schema:
>> test(a varchar2(2) not null, b long)
>>Where a is my identifier and b is of type long.
>>My problem is this, Long can support up to 2gb of data, but I
>>am unable to enter anything over 2000 characters because of
>>Oracle's 2000 max chars on quoted strings. Triggers and Functions
>>have proven useless. Please help!!!
>
>>Thanks,
>
>The way I've figured out to deal with this is to write little
>PL/SQL procedures to update the string a bit at a time. I.e. read
>in the first 2000 chars, add this to the database, read in the
>next 2000 chars, in the pl/sql procedure, read in the string so far,
>from the database, append the new 2000 chars, save in the database,
>read in the next 2000 chars, etc.
>
>Of course, PL/SQL can only take a 32,000 char varchar2, but that's better
>than 2000.
>
Nicolas
Nissakid_at_planete.net
Microsoft Certified Product Specialist
AUI Member
The above represents my own opinion not my employer's and does not necessarily constitute the official policy of my employer. Any opinion developed through this account represent a private conversation. Received on Tue Jun 16 1998 - 18:53:59 CDT
![]() |
![]() |