TD 5.1, TD 4.2: oracle connect - OCI_INVALID_HANDLE

[prieschr]

In the profile of an oracle user some special password settings can be used (e.g. failed login attempts, password lifetime, password grace time, ...).

Since Oracle 11 the default profile contains settings for the password lifetime and the password grace time.

It´s possible to catch specific error (e.g. account locked, password expired, etc) with TD. But it´s not possible to catch the "warning" which is produced by the "Password grace time" setting in the profile.

In this case an error 20002 OCI_INVALID_HANDLE occurs at sqlconnect. The same error occurs with sqltalk. This happens with TD 4.2 and TD 5.1 (SP5).

sqlplus:
ERROR:
ORA-28002: the password will expire within 10 days
Verbunden mit:
Oracle Database 10g Release 10.2.0.3.0 - Production

toad:
ignores the error 28002

Is there any way to catch this warning/error?

Thank you for your help.

Regards,
Reinhard

[PeterFr]

Hello,

today we have the same problem by a customer.
Only with sqlplus we can see the error message of password expiration.
Anybody knows a solution for this?
Thanks!