How to check file exist in folder [message #662705] |
Wed, 10 May 2017 01:59 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/2b99529a73e8a5f8357a2fc814945434?s=64&d=mm&r=g) |
er.surana
Messages: 4 Registered: July 2015 Location: INDIA
|
Junior Member |
|
|
How to check file available in folder, if exist then validate the file
i am using oracle form6i and toad
i used host command it works but i want validation also.
my code
-----
DECLARE
str2 varchar2(3000);
--v_path varchar2(100):='D:\test\';
t varchar2(1000);
BEGIN
for i in (select filenm from temp_tst_file_chk)
loop
str2:='D:\test\'||i.filenm;
host('cmd/c'||str2,NO_SCREEN);
END IF;
end loop;
EXCEPTION
WHEN no_data_found THEN
message('no found');
message('no found');
WHEN OTHERS THEN
message('OTHER ISSUE');
message('OTHER ISSUE');
END;
-----
|
|
|
|
|