OraFAQ Forum: Client Tools » SP2-0642: SQL*Plus internal error state 2501, context 3:0:0

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

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

SP2-0642: SQL*Plus internal error state 2501, context 3:0:0 [message #629345]

Mon, 08 December 2014 02:53

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

cookiemonster
Messages: 13894
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.

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 67743
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Add what I said and execute again and tell us.

Report message to a moderator

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

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

Report message to a moderator