PLS-00364: loop index variable 'X' use is invalid
614689Dec 21 2007 — edited Dec 21 2007Hi I am getting the error while compiling the code. can some one plese help on this .Here is the code
BEGIN
FOR x IN (select i_bk_org_accss_lvl,f_rls_sec_grp
from sap_sys_user_stat
where i_sys_user = user_id
and c_rls_stat = 'A'
and (d_end is null or d_end = '12-31-9999'))
LOOP
internal_flag := x.i_bk_org_accss_lvl;
rls_grp_flag := x.f_rls_sec_grp;
END LOOP;
END;