| How to check file exist in folder [message #662705] |
Wed, 10 May 2017 01:59  |
 |
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;
-----
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
