With Oracle, you can capture the SQLDBCODE 28001 that indicates the user's password is expired. 

One way is to create you own change password window. The downside with this is that you need a service account that has the appropriate permission to change the user password. Most likely the password of the service account will be hard coded in the application and should not expire. The upside is that you can add additional user verifications for the user identity and you are also able to log the activity.

So, basically it would be like:

CONNECT USING SQLCA;

If SQLCA.SQLDBCODE = 28001 Then

    // connect using the service account

    // open w_changepassword window. So this is now your custom change password dialog window and you can add any validations/verifications you want.                 

   // log the activity

    // disconnect

    // back to the login prompt

End If

Another way is to still capture the SQLDBCODE 28001 (with no PWDialog yet). If you get that code, display the password requirements (could be a message box or a response window). Then re-set the SQLCA.DBPARM to include the PWDialog parameter and then reconnect.

So, it’s like:

CONNECT USING SQLCA;

If SQLCA.SQLDBCODE = 28001 Then

    // display password requirements

   // SQLCA.SQLDBPARM = SQLCA.SQLDBPARM + ‘ PWDialog=1’

   CONNECT USING SQLCA;

End If

You can not display the dialogs and display your own window when you get the connect error.