Hi ,
I created validation for my tabular form.
DECLARE
lv_v_pusers VARCHAR2 (50);
lv_v_susers VARCHAR2 (50);
lv_n_count NUMBER := 0;
BEGIN
FOR i IN 1 .. apex_application.g_f03.COUNT
LOOP
IF apex_application.g_f03 = 'Lead Programmer'
THEN
lv_v_pusers := apex_application.g_f06 (i);
ELSIF apex_application.g_f03 = 'Lead Statistician'
THEN
lv_v_susers := apex_application.g_f06 (i);
END IF;
FOR p_users IN (SELECT REGEXP_SUBSTR (lv_v_pusers,
'[^:]+',
1,
LEVEL
) users
FROM DUAL
CONNECT BY REGEXP_SUBSTR (lv_v_pusers, '[^:]+', 1,
LEVEL) IS NOT NULL)
LOOP
FOR s_users IN (SELECT REGEXP_SUBSTR (lv_v_susers,
'[^:]+',
1,
LEVEL
) users
FROM DUAL
CONNECT BY REGEXP_SUBSTR (lv_v_susers,
'[^:]+',
1,
LEVEL
) IS NOT NULL)
LOOP
IF p_users.users = s_users.users
THEN
lv_n_count := 1;
END IF;
END LOOP;
END LOOP;
END LOOP;
IF lv_n_count = 1
THEN
RETURN 'Programmer and Reviewer cannot be same' || lv_n_count;
END IF;
END;
And whenever the validation occurs Iam getting this error:
report error: ORA-20001: Error fetching column value: ORA-01403: no data found ORA-06510: PL/SQL: unhandled user-defined exception
Any Idea how to overcome the issue? Iam using APEX 5, Universal Theme.
Thanks & Regards,
Nivetha.