I have written the following simple code on SQL*Plus

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

PL/SQL procedure successfully completed.


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


Regards
Joey

Oracle LazyDBA home page