carriage return / line feed's in text or varchar fields

Hi,

I am writing some scripts which have to update data in an Oracle 8.1.6 database.

The update commands are send by sqlplus
But I am unable to update text or varchar fields when the string contains carriage return / line feed characters, because the CRLF's get interpreted as part of the SQL statement (sp2-0734) instead of part of the character string to be inserted. How do I get CRLF's into a text or varchar field in Oracle?

Thanks,
Andreas

i.e.:

UPDATE contact SET field1='Hi,

this is an update to test CR

Greetings' WHERE ckey=4711; Received on Sat Mar 08 2003 - 12:36:02 CST