Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Password management via C# dotnet app

robjaFeb 9 2010
I would like my C# app to handle all the relevant ORA-errors and react to them as appropriate.
I can today handle error in user/passw(ORA-1017) , password locked (ORA-28000) and expired password(ORA-28001).
Here I use OracleConnectionStringbuilder and Open() and OpenWithNewPassword().

BUT how do i get and react to ORA-28002 and ORA-28011.
These ORA errors does not appear to be transferred to my app(I can detect them in toad, but not in my codes exception clause). ONly when the password really is expired do i get the ORA-28001.

The questions are:
1. How can I detect the ORA-28002 and ORA-28011 in my C# code?
2. What odp.net function do i call with my connection to change passw. If the user will change passw after receiveing ORA-28002 and ORA-28011 ?(from what i read I cannot use OpenWithNewPassword)
3. How do I change password directly from c#. Via a meny command from my app? Is it only possible via a execute alter command?

Hope that someone can help me.
/Robert
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 9 2010
Added on Feb 9 2010
0 comments
2,148 views