1 2 Previous Next 23 Replies Latest reply: Nov 30, 2012 12:25 AM by user7197586 RSS

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

    user7197586
      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