From: "Allan Martin" <allan.martin@saic.com>
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.databases.oracle.tools
Subject: Carriage Return
Date: Tue, 4 Dec 2001 12:01:44 -0000
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 10.89.3.109
X-Original-NNTP-Posting-Host: 10.89.3.109
Message-ID: <3c0c4aa9$1@cpns1.saic.com>
X-Trace: 4 Dec 2001 04:01:45 -0800, 10.89.3.109
Path: news.easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!mvb.saic.com!cpns1.saic.com
Xref: easynews comp.databases.oracle.misc:73261 comp.databases.oracle.server:127101 comp.databases.oracle.tools:46858
X-Received-Date: Tue, 04 Dec 2001 05:01:48 MST (news.easynews.com)

Hi,

Does anyone know how to insert a Carriage Return into a field with a
datatype of LONG.

I was working along the lines of:

update tblname set longfield = longfield || chr(13) || 'my new line' where
pk = 'Martin';
commit;

but I'm getting back an inconsistent datatype.

Thanks in advance,

Allan Martin