| ora-06550 [message #234405] |
Tue, 01 May 2007 08:52  |
plshelp
Messages: 205
Registered: January 2007
|
Senior Member |
|
|
Hi,
I have a user not able to connect to the database using the application and its giving the below error:
ORA-06550:line 1,column 19:
PLS-00201:identifier 'PS_STD.VALID_USER' must be declared
ORA-06550:line 1,column 7:
PL/SQL:Statement ignored
BEGIN :outcome := PS_STD.VALID_USER(:userid); END;
The database version is 9.2.0.7 and the OS is Solaris9. Surprisingly, the user is able to connect to the database using the Sqlplus. She is not able to connect just via the application.
She is able to connect from other user's machines.
Help appreciated. Thanks.
|
|
|
|
| Re: ora-06550 [message #234407 is a reply to message #234405] |
Tue, 01 May 2007 09:06  |
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
|
Senior Member |
|
|
| plshelp wrote on Tue, 01 May 2007 08:52 | the user is able to connect to the database using the Sqlplus. She is not able to connect just via the application.
She is able to connect from other user's machines.
|
From sqlplus,Is she connecting as same user as she use in application?
If yes,did she try to execute the procedure from sqlplus?is it working ?
|
|
|
|
| Re: ora-06550 [message #234417 is a reply to message #234405] |
Tue, 01 May 2007 09:42 |
plshelp
Messages: 205
Registered: January 2007
|
Senior Member |
|
|
Thanks for your reply,Gkrishn.Yes, the user is connecting with the same username in sqlplus.
THe user did not execute any procedure in the application as far as i know, since she doesnt know anything about sql.
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ora-06550 [message #239943 is a reply to message #234405] |
Wed, 23 May 2007 12:59 |
plshelp
Messages: 205
Registered: January 2007
|
Senior Member |
|
|
Hi all,
The user all of a sudden was able to connect to the database for 3 weeks now.. without making any changes..thats really strange..
But again she has the same problem..The same user is able to connect to the database using other machine's applications.
She is able to connect using sql*plus using the same username.
And tnsping and ping to the server is working.
The database she is trying to connect is in England.. She is able to connect to the local databases through the application wihtout any problem.
Please give me your suggestions.
Thanks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
