Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Inserting Large Amount of Data into LONG

Inserting Large Amount of Data into LONG

From: Magaliff, Bill <Bill.Magaliff_at_lendware.com>
Date: Tue, 3 Aug 2004 12:51:29 -0400
Message-ID: <BA5D5F7D75A5D511A69E00508B73040C049D633B@fwmail.frameworkinc.com>


Hello:

I have an engineer who would like to insert roughly 11K into a LONG column through SQL. It's ASCII "formatted" data (with carriage returns, spaces, etc.) that we will receive via XML. We can massage, reformat as needed but it needs to go into a LONG (using CLOB not an option due to other application incompatibilities).

Straight SQL doesn't work (length of the quoted string too long) and I tried creating a Stored Proc to handle it, but I get Invalid Sql Statement - due I think to the presence of the carriage returns, which Oracle is not recognizing as a continuation from the previous line.

Any thoughts on how to proceed?

Thanks

-bill magaliff



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Tue Aug 03 2004 - 11:47:41 CDT

Original text of this message

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