Not display ORA-28002 error

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ysyang
Posts: 44
Joined: Tue 14 Jun 2005 09:10

Not display ORA-28002 error

Post by ysyang » Tue 29 Jun 2010 10:26

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)

bork
Devart Team
Posts: 649
Joined: Fri 12 Mar 2010 07:55

Post by bork » Wed 30 Jun 2010 15:53

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.

ysyang
Posts: 44
Joined: Tue 14 Jun 2005 09:10

Post by ysyang » Fri 02 Jul 2010 02:27

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

bork
Devart Team
Posts: 649
Joined: Fri 12 Mar 2010 07:55

Post by bork » Tue 06 Jul 2010 07:04

Hello

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

ysyang
Posts: 44
Joined: Tue 14 Jun 2005 09:10

Post by ysyang » Tue 06 Jul 2010 23:50

Hi

I used Direct connection.

bork
Devart Team
Posts: 649
Joined: Fri 12 Mar 2010 07:55

Post by bork » Wed 07 Jul 2010 15:46

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.

ysyang
Posts: 44
Joined: Tue 14 Jun 2005 09:10

Post by ysyang » Mon 12 Jul 2010 05:12

Thank you so much for your hard work

Post Reply