Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PL/SQL proc and '&'

PL/SQL proc and '&'

From: Haresh Assumal <assumal_at_sprynet.com>
Date: Fri, 8 May 1998 10:52:19 -0400
Message-ID: <6iv4kn$e5d$1@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:52:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US