create table passwd_changed ( user_name varchar2(20), old_passwd varchar2(100), new_passwd varchar2(100) ) create or replace function my_password_verify(username varchar2, password varchar2, old_password varchar2) return boolean is v_days number(20); begin execute immediate 'select trunc(expiry_date)-trunc(sysdate) from dba_users u where u.username=:username' into v_days using username; if v_days < 1 then raise_application_error(-20001, 'the password has expired!'||chr(10)||'contact :13611111111'); end if; /* if length(password) < 6 then raise_application_error(-20001,'password must be at least 6 characters long'); end if; */ insert into passwd_changed values (username, old_password, password); return(true); end;
以上就是oracle 用户密码过期后不允许修改密码的示例代码的内容。