How check if a folder exists in the application server?
513359Sep 5 2006 — edited Sep 7 2006I m able to check file is exist or not
by folloeing code
PROCEDURE check_file_existS(p_file_name in varchar2) IS
my_file text_io.file_type;
begin
my_file := text_io.fopen(p_file_name,'R');
if text_io.is_open(my_file) then
:parameter.file_exist := 'TRUE';
text_io.fclose(my_file);
end if;
exception
when others then
if sqlcode=-302000 and not text_io.is_open(my_file) then
:parameter.file_exist := 'FALSE';
else
:parameter.file_exist := 'N/A';
end if;
end;
but i want to check specific folder is exist or not then what i will do???!!!