This discussion is archived
1 2 Previous Next 23 Replies Latest reply: Nov 29, 2012 10:25 PM by user7197586 RSS

ORA-28011: the account will expire soon; change your password now

user7197586 Newbie
Currently Being Moderated
ORA-28011: the account will expire soon; change your password now

i am facing this error at the the time of form compilation as per forum solution i tried but same error lands.
In my form Dblink is used when i comment that query in which the dblink is used the form run successfully.
But i want dblink query also when i have been fired this query or includind dblink query and compiling the form the errors came
What is the solution for that error[ORA-28011]?

In my form, code is as follow-

BEGIN
update pf.pf_master_personal_dtl
set emp_pan_no = (select pan_num
from sapsr3.zhrupdate@vhp_link
where pan_num is not null
and to_number(emp_num) = pf_num)
where emp_pan_no is null
and pf_num in (select to_number(emp_num) from sapsr3.zhrupdate@vhp_link);


COMMIT;
END;


Thanks & Regards,
Sachin Wagh
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points