Hi Guys,

I am trying to validate password using pl/sql procedure i am passing user name and password as a IN parameter and i wan to check that this user name and password is correct OR exist ? i know that i can select from DBA_USERS vies but oracle stores password in encrypted format so, whenever it try to check password it does not match with password in DBA_USERS view although i am passing correct user name and password can any one through some light on it ?