Re: Newbie needs help with special characters

From: Gerrit-Jan Linker <linker_at_oraxcel.com>
Date: Sun, 2 Apr 2000 21:00:34 +0100
Message-ID: <8c9i5h$s4$3@news6.svr.pol.co.uk>

Not that I'm aware of.

Be careful with a ' character as it can be interpreted as the end of string character. I've had some trouble passing binary data (all asci values will be used at some point) with the usual binary chars like all under 13 and some above 200. I replaced those using the char pl/sql function:

string = substr1 || char(13) || char(10) || substr2;

Hope this helps,

Gerrit-Jan Linker
Linker IT Consulting Limited
http://www.oraxcel.com

Developer of
Oraxcel, the Oracle to Excel link
OraCodes, Oracle error codes explained
OraSQL, Oracle SQL explained
OraDebug, an Oracle PL/SQL debugger.
<wingo01_at_my-deja.com> wrote in message news:8c7tdv$g92$1_at_nnrp1.deja.com...
> Is there a list of characters that Oracle needs to have treated as
> special characters and use the escape sequence.
>
> Thanks
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Apr 02 2000 - 15:00:34 CDT