Password will expire message not displaying

[babsjoy]

It seems since we have upgraded to 10g (version 10.2.0.1.0) When executing batch jobs (to execute PL/SQL packages via SQLPLUS)the Oracle messsage

ORA-28002; the password will expire within XX days

is no longer appearing in the output log.
I have done some research and the SQL*PLUS release notes for V 10.1 dated December 2003 states this as a known issue. How can this be corrected? The account used to perform the batch execution was set up with a grace_period of 10 days. Any ideas?

 

[Beilstwh]

Sure, modify your script to have the following code

set serveroutput on
declare
days number;
begin
  select nvl(EXPIRY_DATE,sysdate + 1) - sysdate
  into days
  from user_users;

  if days > 0 and days <= 10 then
   dbms_output.put_line('ORA-28002: The password will expire within '||to_char(trunc(days))||' days');
  end if;
end;
/

Bill
Oracle DBA/Developer
New York State, USA

 

[babsjoy]

Thanks.. I will try that...