Re: Getting data in to LONGs

From: Stewart Houck <shouck_at_salud.unm.edu>
Date: 1997/11/25
Message-ID: <347B4DA9.5D37@salud.unm.edu>#1/1

Andy McLeod wrote:
>
> I'm sure this is a dumb question, but how do I get
> large quantities of text into LONG fields? I can't
> use
>
> INSERT VALUES('<loads of text>')
>
> as Oracle barfs if the quoted string is over 2000
> characters.
>
> Suggestions welcome.
>
> thx/andy

I've read in this news group that you can use bind variables or PL/SQL to get around the 2000 character limit. Anyway, check out dejanews, as the answer has been posted before with examples. Received on Tue Nov 25 1997 - 00:00:00 CST