SQL*PLUS Long data

From: ccrissma_at_ucs.att.com <(ccrissma_at_ucs.att.com)>
Date: 1995/09/29
Message-ID: <1995Sep29.200553.29580_at_ucseng.ucs.att.com>#1/1


Help please! I am attempting to insert some data into a long type field via a sql script with SQL*PLUS. My long text has some blank lines. Like this:

insert into tablename
values ('non_long_field_value',
'long data - test test text test text
test test test

test test tes
test tes test tes
tes tes test trext

blah blah blah');

It handles the first 2 lines of the long and then gives me an error at the start of line 4 (line after the 1st blank line).

What am I doing wrong? I thought EVERYTHING between the single quotes (') was treated as one chunk.

Any help would be appreciated. Thanks.

-- 
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

Charlie Crissman - ccrissma_at_ucs.att.com
AT&T Universal Card Services - Database Administration
(904) 954-8159
Received on Fri Sep 29 1995 - 00:00:00 CET

Original text of this message