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

Thanks T.S.S.!!! CHR(10) did the trick!

Regards,
Dave

T.S.S. wrote in message <36A4F299.123150B4_at_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 - 17:14:00 CST