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 -> HELP: Inserting big string literals into LONGs

HELP: Inserting big string literals into LONGs

From: Kevin White <kevin.white_at_blackwell.co.uk>
Date: Thu, 15 Apr 1999 11:15:42 +0100
Message-ID: <3715BC4E.E65BCFBF@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 - 05:15:42 CDT

Original text of this message

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