Home » SQL & PL/SQL » Client Tools » SP2-0317: expected symbol name is missing (10.2.0.3.0)
SP2-0317: expected symbol name is missing [message #402200] Fri, 08 May 2009 01:17 Go to next message
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 #402201 is a reply to message #402200] Fri, 08 May 2009 01:22 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Messages: 499
Debug my problem, or you are banished!
Re: SP2-0317: expected symbol name is missing [message #402202 is a reply to message #402200] Fri, 08 May 2009 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
But I can't find any syntax error in the code.

We can't either, see what you posted.
Do you know how to debug code, any code?

Regards
Michel
Re: SP2-0317: expected symbol name is missing [message #452498 is a reply to message #402200] Thu, 22 April 2010 07:10 Go to previous messageGo to next message
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 #452513 is a reply to message #452498] Thu, 22 April 2010 07:49 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Heh, really, where is user71408? He's been away for 5 months now.

uwer71408
But I can't find any syntax error in the code
I hope he didn't lose his way in code labyrinth.
Re: SP2-0317: expected symbol name is missing [message #452514 is a reply to message #452498] Thu, 22 April 2010 07:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I'm sure the problem has long been solved

Do not bet your life on it, you don't know OP as we know it but I'm pretty sure he didn't solve his problem.

Regards
Michel
Re: SP2-0317: expected symbol name is missing [message #452530 is a reply to message #452514] Thu, 22 April 2010 08:27 Go to previous messageGo to next message
JulesLt
Messages: 3
Registered: April 2010
Location: Leeds, UK
Junior Member
Yes, some of the other posts have provided me with some amusement. Perhaps he's no longer working??

Re: SP2-0317: expected symbol name is missing [message #452533 is a reply to message #402200] Thu, 22 April 2010 08:32 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Considering his complete inability to grasp basic concepts it wouldn't suprise me.

I'm not convinced this error is due to &, I've run in code with that before and never seen that error.

Suggest file under M for mystery.

EDIT: typo

[Updated on: Thu, 22 April 2010 08:33]

Report message to a moderator

Re: SP2-0317: expected symbol name is missing [message #452536 is a reply to message #452533] Thu, 22 April 2010 08:50 Go to previous messageGo to next message
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)

Re: SP2-0317: expected symbol name is missing [message #452537 is a reply to message #402200] Thu, 22 April 2010 08:57 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
If you've hit it fair enough, will take your word for it.
Re: SP2-0317: expected symbol name is missing [message #452594 is a reply to message #452537] Thu, 22 April 2010 23:04 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
SQL> set define on
SQL> set define &
SP2-0317: expected symbol name is missing
SQL> set define '&'
SQL> select sysdate
  2  --this is a comment & wont work
  3  from dual;
Enter value for wont:
old   2: --this is a comment & wont work
new   2: --this is a comment  work

SYSDATE--
---------
23-APR-10


SQL> select sysdate
  2  --this is a comment &
  3  wontwork
  4  from dual;
SP2-0317: expected symbol name is missing

WONTWORK
---------
23-APR-10


srriam Smile
Previous Topic: Semicolon ; is not interpreted correctly.. :(
Next Topic: Need assistance with passing variable and displaying Select data in TOAD
Goto Forum:
  


Current Time: Fri Dec 09 13:30:33 CST 2016

Total time taken to generate the page: 0.22269 seconds