In oracle we have users with passward expiry date. when the passward expires a message is prompted on screen that passward is about to expire. It is done implicitly by Oracle.

We have developed an web application using Oracle backend for a client. In this application we have created application Users. We have created a Table say users in which we have defined col.
as username,passward, expiry date. when ever user login to application it checks user name/passward and expiry date in users table. if the expirydate is reached a message is prompted that changed the application user passward.

Now the client wants to connect these application users with Oracle users. The requirement is that wheneven Oracle users passward Expiry message appeare on screen the same message will be catched and displayed in application software. Means when Oracle gives warrning about oracle users passward going to expire same message will appear for application software user, and application user and Oracle users passward both needs to be changed.