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 -> Re: 2000 character limitation problem

Re: 2000 character limitation problem

From: Nicolas Issakides <nissakid_at_planete.net>
Date: Tue, 16 Jun 1998 23:53:59 GMT
Message-ID: <35870598.0@news.kampot.pci>


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

Original text of this message

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