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

Collapse
1: How do you escape the @ sign in Oracle?
Posted by Ola Hansson on 06/30/03 06:22 PM
Just to make the question a little more clear I'll provide some example code from the file-storage create script ... 
    template_id := content_template.new(
        name  =>  'file-storage-default',
        text  =>  '<master>
<property name="title">@title@</property>
<property name="context">@context@</property>
@text;noquote@'
    );
When I leave the "@text;noquote@" at the beginning of a line, Oracle thinks it should source a file. Is there a way around this but still having it at the beginning of a new line?

Thanks.

Collapse
2: Re: How do you escape the @ sign in Oracle? (response to 1)
Posted by Jun Yamog on 06/30/03 07:13 PM
Hi Ola,

I am not sure about.  But from what I remember when I had to insert a lot of data in Oracle that included email addy that had "@".  I do a "set define off;" on top.  I am not sure if this will work.  Hope this helps.

Collapse
3: Re: How do you escape the @ sign in Oracle? (response to 1)
Posted by Ola Hansson on 06/30/03 11:28 PM
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

Collapse
4: Re: How do you escape the @ sign in Oracle? (response to 1)
Posted by Don Baccus on 07/01/03 01:51 AM
What happens if you assign the string to a Tcl var then use the bindvar notation to stuff it into Oracle?

That should trick it, no?  Seems easier than remembering to set escape on all the time.