Re: Loading a large text string

From: Steve mouatt <steve_at_bedrockcomputers.demon.co.uk>
Date: 1998/01/13
Message-ID: <34BB66D9.76FE@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 CST