Re: Can I insert <CR><LF> in VARCHAR?

From: T.S.S. <tss_at_webspace.com.au>
Date: Wed, 20 Jan 1999 07:31:14 +1030
Message-ID: <36A4F299.123150B4@webspace.com.au>

Have you tried appending the characters directly using CHR(?)???

i.e. 'Existing String'||CHR(10)||CHR(13)'Continuing String'

Dave Nels wrote:

> Hello,
> I have an C external procedure that expects as a parameter a string that
> represents the body of an email message. My problem is I can not figure out
> how to insert a binary carriage-return, line-feed pair into a string literal
> that is the corresponding VARCHAR parameter in my PL/SQL function that is
> the proxy for this external procedure. Can this be done
>
> Thanks,
> Dave Nels
Received on Tue Jan 19 1999 - 15:01:14 CST