Re: An interest situation using "&" in PLSQL comment line

Your SQLPLUS 'define' parameter is set to &

Simply enter:

set define off

Before you compile your procedure

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

Author of: 'So You Want to be an Oracle DBA?'

"C Chang" <cschang_at_maxinter.net> wrote in message news:3D058057.2B35_at_maxinter.net...
> When I added a new private function to the package body, I put a comment
> line at the top like :
> -- This is a function to use ID to search D&B number
> FUNCTION..
>
> However, when I compiled the package body, the compiler asked "the value
> for b:"
> After I entered a number say 5, the compiler responded with
> old 13: -- This is a function to use ID to search D&B number
> new 13: -- This is a function to use ID to search D5 number
> then compile successfully.
> Why the comment line with &B will replace the 5 that I entered? my
> ORacle PL/SQL book does not mention any about this. I thought using the
> "-- ..", compiler is supposed to ignore the line. Does any one know
> this?
>
> C Chang
Received on Tue Jun 11 2002 - 05:29:19 CDT