Re: PL/SQL proc and '&'

From: Hayden Worthington, Inc. <hayden_at_mindspring.com>
Date: Mon, 11 May 1998 10:40:33 -0400
Message-ID: <35570DE0.D078D2B6@mindspring.com>

Haresh,

 before you run the proc script just do a

 SQL> set define off

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

--

---

Hayden Worthington, Inc.       Oracle Performance Tuning
5696 Peachtree Parkway         www.mindspring.com/~hayden
Norcross, Georgia 30092        White Papers, Scripts, etc.

800 844-0497 Received on Mon May 11 1998 - 09:40:33 CDT