Page 1 of 1

Not display ORA-28002 error

Posted: Tue 29 Jun 2010 10:26
by ysyang
Hi

I'm connect Oracle Server to SQL*Plus and display command message
-----------------------------------------------------------------
SQL> connect a7/a7
ERROR:
ORA-28002: the password will expire within 0 days

Connected.
-----------------------------------------------------------------

But when connect TOraSession, ignore error message.
No more display to OnInfoMessage event

ODAC version : 6.90.0.58
ORACLE : 10.2.0.1(XE)

Posted: Wed 30 Jun 2010 15:53
by bork
Hello

If 0 days left before the password expires, then you will get error message with code 28011 instead of the error message with code 28002.

You can find more detailed information about these errors in the Oracle documentation.

Posted: Fri 02 Jul 2010 02:27
by ysyang
Hello

I'm not found any more error (28011,28002, etc )

I think happen any error (28011,28002, etc ) to OnInfoMessage event
but no more display to OnInfoMessage event

and ora-28002 error is happen to SQL*Plus

Posted: Tue 06 Jul 2010 07:04
by bork
Hello

Please specify what connection are you using: OCI or Direct?

Posted: Tue 06 Jul 2010 23:50
by ysyang
Hi

I used Direct connection.

Posted: Wed 07 Jul 2010 15:46
by bork
This issue can occur in the Direct mode only. Now this error is fixed and this fix will be included in the next ODAC build.

Posted: Mon 12 Jul 2010 05:12
by ysyang
Thank you so much for your hard work