Re: PL/SQL proc and '&'

Probably, you run script from SQL*Plus.... SQL*Plus assumes that word after '&' is a variable name which would be replaced with a parameter. If you REALLY HAVE TO place '&' char in your SQL script, you should run it from svrmgrl (unix) or svrmgr<xx> (NT, Win95) or sqldba in line mode (earlier releases).
But to tell you the truth... In your case, it is much much simplier to replace '&' with 'and' ;-)

HTH, Piotr
pkol_at_otago.gda.pl

Haresh Assumal wrote in message <6iv4kn$e5d$1_at_news3.microserve.net>...
>I am having trouble in creating a PL/SQL procedure that has an '&'. When I
>run the script to create a proc using SQL Plus I get prompted for inputs
>whenever there is an '&' character. This happens even if its a comment:
>Eg:
>create or replace procedure test
>is
> /* Name & address */
> insert into foo values ('XXXXX','1212 eeeeee');
>end;
>
>It does not like the '&' in the comment or even in a string. How do I get
>this to work?
>Thanks,
>Haresh
>email: assumal_at_sprynet.com
>
>
>
Received on Fri May 08 1998 - 09:49:27 CDT