Re: SQL*PLUS problem avoiding variable interpolation in strings

dlincke_at_bandon.unisg.ch (David-Michael Lincke) wrote:
>I have insert statements of the following kind in an SQL*PLUS script file
>
>insert into table values ('Öffentlichkeit', 'Stra&zslig;e...
>
>Now SQL*PLus takes the SGML entities as variables to be interpolated. Is
>there anyway I can stop it from doing this? Escaping with \ or doubling the
>& doesn't help.
>
>dave
>
>--
>David-Michael Lincke Institute for Information Management at USG
>EMail: dlincke_at_sgcl1.unisg.ch
>URL: http://www-iwi.unisg.ch/about/team/dal.html

Dave,

You can "disable" the & character's behavior in SQL*Plus by issuing the following at the top of your SQL script:

SET DEFINE OFF Likewise, you can "turn it back on" following the inserts.

Hope this helps!

-- 
Mike Morgan
Technology Integration Services - Unix DBA

email: mike.morgan_at_teldta.com

TDS Computing Services
301 S. Westfield Road
Madison, WI 53705  USA
(608)845-4661

"Murphy's Law of computing:  Anything that can go wrSegmentation 
fault(coredump)"
*******************************************************