APEX

Hi,

Can one help me How to put validation i.e raise_application_error(-20201,'Score card exist for'||v_str||' records cannot be deleted');


using below mentioned PL/SQL code.



Declare
v_num Number(20):=0;
v_num2 Number(20):=0;
v_str VARCHAR2(3200):=null;
check_it number;
Begin

FOR I IN 1..APEX_APPLICATION.G_F01.COUNT LOOP
Select APEX_APPLICATION.G_F01(i) into check_it from dual;
SELECT COUNT(1) INTO V_NUM FROM IST_SCORECARD_FILES
WHERE INT_COMP_ID=check_it;
if v_num >=1 THEN
v_num2:=v_num2+v_num;
v_str:=v_str+APEX_APPLICATION.G_F02(i)
END IF;

END LOOP;
IF v_num2 >=1 THEN
raise_application_error(-20201,'Score card exist for'||v_str||' records cannot be deleted');
END IF;

End;

Thanks and regards,
Ibrahim Sayyed.