hi am in forms 12 using oracle database 19c
this the code FUNCTION is_Generated(v_path_File varchar2 ) RETURN varchar2 IS
v_cnt_line varchar2(33000);
v_cnt_file TEXT_IO.FILE_TYPE;
result varchar2(5);
BEGIN
result:='TRUE';
BEGIN
v_cnt_file := TEXT_IO.FOPEN(v_path_File,'r');
TEXT_IO.GET_LINE(v_cnt_file,v_cnt_line);
TEXT_IO.FCLOSE(v_cnt_file);
EXCEPTION WHEN OTHERS THEN
TEXT_IO.FCLOSE(v_cnt_file);
result:='FALSE';
END;
return result;
END;