When Col-1 value is A the LOV of Col-2 has values AA BB CC and Col-3 has 1 2 3
Col-1 Col-2 Col-3 A AA 1 A BB 2 A CC 3 B AA 1 B AAB 2 B AAV 3
since it needs to check if the value is in the range of alowed values. In my example I created a fake second entry which has the same ID and there it is enough to do RETURN item value session state.
DECLARE v_empno NUMBER; BEGIN SELECT empno INTO v_empno FROM emp WHERE deptno = :p292_deptno AND empno = :p292_empno; RETURN v_empno; EXCEPTION WHEN OTHERS THEN RETURN v_empno; END;