OraFAQ Forum: Client Tools » SP2-0317: expected symbol name is missing

Home » Other » Client Tools » SP2-0317: expected symbol name is missing (10.2.0.3.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: SP2-0317: expected symbol name is missing [message #402201 is a reply to message #402200]

Fri, 08 May 2009 01:22

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Messages: 499
Debug my problem, or you are banished!

Report message to a moderator

Re: SP2-0317: expected symbol name is missing [message #402202 is a reply to message #402200]

Fri, 08 May 2009 01:29

Michel Cadot
Messages: 68643
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

Report message to a moderator

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.

Report message to a moderator

Re: SP2-0317: expected symbol name is missing [message #452513 is a reply to message #452498]

Thu, 22 April 2010 07:49

Littlefoot
Messages: 21807
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.

Report message to a moderator

Re: SP2-0317: expected symbol name is missing [message #452514 is a reply to message #452498]

Thu, 22 April 2010 07:50

Michel Cadot
Messages: 68643
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

Report message to a moderator

Re: SP2-0317: expected symbol name is missing [message #452530 is a reply to message #452514]

Thu, 22 April 2010 08:27

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??

Report message to a moderator

Re: SP2-0317: expected symbol name is missing [message #452533 is a reply to message #402200]

Thu, 22 April 2010 08:32

cookiemonster
Messages: 13920
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

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)

Report message to a moderator

Re: SP2-0317: expected symbol name is missing [message #452537 is a reply to message #402200]

Thu, 22 April 2010 08:57

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

If you've hit it fair enough, will take your word for it.

Report message to a moderator

Re: SP2-0317: expected symbol name is missing [message #452594 is a reply to message #452537]

Thu, 22 April 2010 23:04

ramoradba
Messages: 2456
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 16:40:45 CDT 2024