Wieland,
Thanks a lot.

Regards,
Joey




-----Original Message-----
From: Wieland Pusch
[mailto:oracledba-ezmlmshield-x39824984.[Email address protected]
Sent: Friday, October 08, 2004 3:38 PM
To: LazyDBA Discussion
Subject: Re: Ampersand '&' within comment - piculiar problem


Hello Verma,

because SQL*Plus does simple string replace.

You can set verify off.

You can use "+" instead of "&". I would do that.

You can use this feature:
SQL> def friend="Jerry"
SQL> BEGIN
2 /* MY COMMENT -- > Tom and &friend */
3 NULL;
4 END;
5 .
SQL> /
old 2: /* MY COMMENT -- > Tom and &friend */
new 2: /* MY COMMENT -- > Tom and Jerry */

PL/SQL procedure successfully completed.

Friday, October 8, 2004, 10:34:40 AM, you wrote:
VJ> I have written the following simple code on SQL*Plus

VJ> BEGIN
VJ> /* MY COMMENT -- > Tom & Jerry*/
VJ> NULL;
VJ> END;
VJ> /
VJ> Enter value for jerry: Why are you asking here..??
VJ> old 2: /* MY COMMENT -- > Tom & Jerry*/
VJ> new 2: /* MY COMMENT -- > Tom Why are you asking here..??*/

VJ> PL/SQL procedure successfully completed.


VJ> Why at all Oracle should ask for the value of any bind variable when
VJ> I am not intending to put it in as an executable statement. The
VJ> ampersand is within comment. Please clarify.

HTH
Wieland mailto:[Email address protected]



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page