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-
set emp_pan_no = (select pan_num
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);
Hi,I am executed the alter statement for 'system/manager@hrall_tcp' .The statment executed Successfully.but when i am compiling the form it's gives same error at the time of form compilation for user 'sapsr3' .the error comes at 'sapsr3.zhrupdate@vhp_link'.I am using in my form.
at the time of '.fmx' file generation it's gives error as- "ORA-28011: the account will expire soon; change your password now"