Re: PL/SQL proc and '&'

From: Rajesh Abhyankar <rajesh_at_dont_spam.writeme.com>
Date: Fri, 08 May 1998 16:47:15 +0100
Message-ID: <35532902.E70A5185@dont_spam.writeme.com>

Haresh,

there are 2 things you can do to solve the & problem: 1) SET SCAN OFF in sqlplus and then run the pl/sql script to create package/procedure/function OR
2) SET ESCAPE ON in sqlplus and use a backslash \ in front of each occurance of &. Then sqlplus will replace \& with & while creating the package/procedure/function.

cheers,
rajesh

Haresh Assumal wrote:

> 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 - 10:47:15 CDT