Forum OpenACS Q&A: Re: How do you escape the @ sign in Oracle?

Collapse
Posted by Ola Hansson on
Hi there Jun,

I ended up using "set escape on" before the transaction I had the code in, and a "\" in front of the "@". The default escape character ("\") is disabled by default.

"set define on" is useful for dealing with strings with ampersands ("&"). At least that's what I learned from some Googling ...

/Ola