Re: Loading a large text string
From: Steve mouatt <steve_at_bedrockcomputers.demon.co.uk>
Date: 1998/01/13
Message-ID: <34BB66D9.76FE_at_bedrockcomputers.demon.co.uk>#1/1
Date: 1998/01/13
Message-ID: <34BB66D9.76FE_at_bedrockcomputers.demon.co.uk>#1/1
David Ng wrote:
>
> Hi,
>
> I don't think you can do any field longer than 32K in SqlPlus. I use
> PL/SQL to overcome this problem last time.
>
> You may try this too.
>
> David Ng
>
>
Sorry but the actual size limitation on PL/SQL varchars is 32767 and the
limit on PL/SQL longs (not to be confused with RDBMS longs which is
indeed two gig) is 32670.
I _think_ that you need to use one of the PRO languages PRO*C etc.
Steve Received on Tue Jan 13 1998 - 00:00:00 CET