title: Oracle not prompting to change the password when password is expired
body: <p>When account_status is expired usually it will prompt to change the password of the next login, But here it throws the below error and closing while connecting through PL/SQL and sqlplus tool. </p>
  
  <p>ORA-00604: error occurred at recursive SQL level 1 
  ORA-06502: PL/SQL: numeric or value error: character string buffer too small. 
  ORA-06512: at line 8 
  ORA-28001: the password has expired </p>
  
  <p>When i try to connect from server. It is prompting to change the password.  What may be the error. FYI-Account_status is not locked.</p>
  
  <p>How to make prompting to change the password in Pl/SQL developer or toad or sqlplus tool when account_status is in expired state?</p>