Home » SQL & PL/SQL » Client Tools » SP2-0642: SQL*Plus internal error state 2501, context 3:0:0 (oracle,11.2.0.3.0,redhat linux 5.10(Tikango))
icon5.gif  SP2-0642: SQL*Plus internal error state 2501, context 3:0:0 [message #629345] Mon, 08 December 2014 02:53 Go to next message
deepaksubramoniam14
Messages: 4
Registered: December 2014
Location: chennai
Junior Member
Hi folks,

expecting your urgent help on this

i have a single sql file comprises of 100 stored procedures and i tried to run the same in command prompt (linux box) on oracle 11.2.0.3.0.

while compiling i getting this error frequently.


SP2-0642: SQL*Plus internal error state 2501, context 3:0:0

am unable to find whether the stored procedure was compiled sucessfully, since some stored procedures showing <sp name > invalid identifier error

please advice what may be the reason for this error and how can i resolve it.

Expecting your urgent help.

Thanks in Advance!!!

With Regards
Deepak Subramoniam
Re: SP2-0642: SQL*Plus internal error state 2501, context 3:0:0 [message #629359 is a reply to message #629345] Mon, 08 December 2014 03:40 Go to previous messageGo to next message
Michel Cadot
Messages: 65840
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Add "set echo on" to your script then you will where the error happens.

Re: SP2-0642: SQL*Plus internal error state 2501, context 3:0:0 [message #629374 is a reply to message #629359] Mon, 08 December 2014 04:25 Go to previous messageGo to next message
deepaksubramoniam14
Messages: 4
Registered: December 2014
Location: chennai
Junior Member
Thanks michel

but i want to know why this error occurs.

because i runned the same script in oracle 11.0.2.0 standard edition (linux box) on redhat 5.11 version

but i never face any error or issues.

can u help me to sort out why this happens,

Expecting your esteemed help.

thanks n Advance!!!

With Regards
Deepak Subramoniam
Re: SP2-0642: SQL*Plus internal error state 2501, context 3:0:0 [message #629375 is a reply to message #629374] Mon, 08 December 2014 04:27 Go to previous messageGo to next message
cookiemonster
Messages: 13265
Registered: September 2008
Location: Rainy Manchester
Senior Member
And without knowing which code causes the error we can't possibly have any idea why it happens.
That's not a standard error you're getting - you're probably best off going to oracle support for help.
Re: SP2-0642: SQL*Plus internal error state 2501, context 3:0:0 [message #629378 is a reply to message #629375] Mon, 08 December 2014 04:53 Go to previous messageGo to next message
deepaksubramoniam14
Messages: 4
Registered: December 2014
Location: chennai
Junior Member
Enter value for customer: SP2-0642: SQL*Plus internal error state 2501, context 3:0:0
Unsafe to proceed
No errors.

this is what i actually got. this is a piece alone
Re: SP2-0642: SQL*Plus internal error state 2501, context 3:0:0 [message #629387 is a reply to message #629378] Mon, 08 December 2014 06:23 Go to previous messageGo to next message
Michel Cadot
Messages: 65840
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Add what I said and execute again and tell us.

Re: SP2-0642: SQL*Plus internal error state 2501, context 3:0:0 [message #629389 is a reply to message #629387] Mon, 08 December 2014 06:37 Go to previous messageGo to next message
deepaksubramoniam14
Messages: 4
Registered: December 2014
Location: chennai
Junior Member
Thanks michael the issue is this happens in customer site and we are unable to rerun the scripts

thanks for your esteemed help, if you got any ideas on this please inform


thanks in advance!!!!
With Regards
Deepak Subramoniam
Re: SP2-0642: SQL*Plus internal error state 2501, context 3:0:0 [message #633396 is a reply to message #629345] Tue, 17 February 2015 09:30 Go to previous messageGo to next message
eudajmonium
Messages: 1
Registered: February 2015
Junior Member
Look for '&' in your code

all best
Re: SP2-0642: SQL*Plus internal error state 2501, context 3:0:0 [message #633403 is a reply to message #633396] Tue, 17 February 2015 10:25 Go to previous message
cookiemonster
Messages: 13265
Registered: September 2008
Location: Rainy Manchester
Senior Member
Any reason why you assume a substitution variable will lead to that error?
Previous Topic: why is sqlplus -v different from select * from v$version
Next Topic: Problem with connection to Oracle Server Enterprise 11g
Goto Forum:
  


Current Time: Tue Oct 16 07:18:24 CDT 2018