Re: HELP: Inserting big string literals into LONGs

From: R. Steven Brown <rstevenbrown_at_earthlink.net>
Date: Thu, 15 Apr 1999 20:53:21 -0600
Message-ID: <7f68n9$sk1$1@fir.prod.itd.earthlink.net>

In PL/SQL CHAR, VARCHAR2 and LONG all have a 32K limit, if your string will fit in that, you should be able to insert it into a LONG datatype column.

+-----------------------------+-----------------------------+
| R. Steven Brown			|	Best Consulting		|
| rstevenbrown_at_earthlink.net	|	1100 East 6600 South	|
| stevenb_at_bestnet.com		|	Suite 200			|
|					|	Salt Lake City UT 84121	|
| "When in danger, or in doubt|	(801) 266-6138 - Office |
|  Run in Circles, Scream and	|	(801) 266-0069 - Fax	|
|  Shout!" Lazarus Long		|	http://bestnet.com	|
+-----------------------------+-----------------------------+

Kevin White <kevin.white_at_blackwell.co.uk> wrote in message news:3715BC4E.E65BCFBF_at_blackwell.co.uk...
>Hi All,
>
>I am trying to insert data from a perl script into a table containing a
>LONG column. The data which I have is longer than 2000 chars and oracle
>complains about this since string literals can only be 2000 chars max.
>The question is... how do I get around this? Is there any way I can
>assign the data to a number of variables and concatonate these into the
>table? or what?
>
>Cheers for any help,
>
>Kevin
>
Received on Thu Apr 15 1999 - 21:53:21 CDT