Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> PL/SQL proc and '&'
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:52:19 CDT
![]() |
![]() |