RE: Problem Inserting "&" sign. (ie. Sampson & Son's)

On Friday, July 05, 1996, Tan La wrote...
> In article <4rgr6s$9dh_at_sol.sun.csd.unb.ca>, pmccarth_at_rpc.unb.ca says...
> >
> >I am trying to insert values into a record using Oracle 7.1.4 on
 Solaris 2.4
> >Sun workstation. The problem is that I am trying to insert a text
 value which
> >has the "&" sign in the text array. ie "Maclary & Son's". It keeps
 coming up
> >with the message insert a value for Son's ?????? It obviously use the
 "&" to
> >insert a variable field. How can I disable this ????
> >
> >Thanks
> >Patrick McCarthy
> >pmccarth_at_rpc.unb.ca
>
>
> If you using SQL*Plus, you can define the substitution character('&')
> to other character by using the Set Define command.
>
> e.g set define '~'
>
> Hope this helps.
>
>

Use

   SET SCAN OFF
in SQL*Plus before the INSERT STATEMENT and then

   SET SCAN ON
after it to re-enable variable subsitution.

Andrew Barnett
abarnett_at_paws.aus.net Received on Mon Jul 08 1996 - 00:00:00 CEST