SP2-0317: expected symbol name is missing [message #402200] |
Fri, 08 May 2009 01:17 |
user71408
Messages: 585 Registered: November 2007 Location: NE
|
Senior Member |
|
|
Hi all,
while executing a package compilation I am getting folloiwng error.
SQL> @PKG_WELCOME.pls
SP2-0317: expected symbol name is missing
Package created.
Package body created.
But I can't find any syntax error in the code. Can any please let me know the solution for this .
Thank you
|
|
|
|
|
Re: SP2-0317: expected symbol name is missing [message #452498 is a reply to message #402200] |
Thu, 22 April 2010 07:10 |
JulesLt
Messages: 3 Registered: April 2010 Location: Leeds, UK
|
Junior Member |
|
|
I'm sure the problem has long been solved, but this may be useful for the next person to Google this error code.
My guess is that you have comments or an output string in your pl/sql code that contain an '&' sign. SQL*Plus expects this to be followed by a substitution variable.
Either replace the '&' with 'and', or add a SET DEFINE to disable substitution, as part of your coding standards for PL/SQL package scripts.
|
|
|
|
|
|
|
Re: SP2-0317: expected symbol name is missing [message #452536 is a reply to message #452533] |
Thu, 22 April 2010 08:50 |
JulesLt
Messages: 3 Registered: April 2010 Location: Leeds, UK
|
Junior Member |
|
|
The reason I put the reply in was because I had the problem this morning - running a SQL script to install a package, which would succeed but give me this 'mysterious' SQL*Plus error code - yet running all the SQL*Plus commands on their own - no error.
Cause was an '&' in the middle of comments in the pl/sql code, when '&' was being used as substitution character in SQL*Plus.
At least the next time I hit this in 2 years time, Googling the error code should bring this up to remind me. (I think it's been 2 years since I last hit it)
|
|
|
|
|