turning off escape character in oracle

From: veranoperu <veranoperu_at_yahoo.com>
Date: 13 Jan 2004 18:02:51 -0800
Message-ID: <d7c10aa.0401131802.20dfa851@posting.google.com>

Bricklen <Xbricklen_at_yahoo.comX> wrote in message news:<TiFMb.72283$JQ1.40482_at_pd7tw1no>...
> veranoperu wrote:
> > Hi all,
> > I'm running into an issue with the escape character '\' and string
> > literals when using oracle. I don't want oracle to process this
> > escape sequence. I know I can use an extra backslash character but
> > that would be inconvenient. In sybase, for example, you can turn this
> > off by "set option Escape_character = 'off'". Does anybody know of
> > the method to do this in oracle.
> >
> > Thanks,
> >
> > Britany Meza
> If you mean turn it off in SQL*Plus, then type:
> set escape off
> in the SQL*Plus window.
> (or: set escape some_other_character)

Thanks for the help. However, I am connecting to an Oracle DB via ODBC. I tried executing 'set escape off' but that didn't work. Any other ideas of how this might be accomplished?

Thanks,
Britany Meza :-* Received on Tue Jan 13 2004 - 20:02:51 CST