Handling ORA-28002
947788Jul 6 2012 — edited Jul 6 2012Hello everybody,
I have recently switched from System.Data.OracleClient to ODP.NET.
With the old namespace I was able to catch the ORA-28002 warning (grace period, "the password will expire within X days") because the code returned an exception with a specific message.
But unfortunately with ODP.NET this exception is not raise, and the user is allowed to enter the application without any warning message.
Could somebody please tell me how to catch the ORA-28002 warning with ODP.NET? This is very important for us and I cannot just give it up.
Any hint is appreciated,
Thank you very much