Re: SQL*PLUS problem avoiding variable interpolation in strings

In article <1995Oct10.164321.3580_at_sgcl1.unisg.ch>, dlincke_at_bandon.unisg.ch (David-Michael Lincke) writes:
|> I have insert statements of the following kind in an SQL*PLUS script file
|>
|> insert into table values ('&Ouml;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

Try 'set define off' or 'set define <another character>. This either turns off substitution, or changes the character. Check out the SQL*Plus manual for more information. Received on Tue Oct 10 1995 - 00:00:00 CET