Home » Developer & Programmer » Forms » How to check file exist in folder (oracle forms6i)
How to check file exist in folder [message #662705] Wed, 10 May 2017 01:59 Go to next message
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;

-----
Re: How to check file exist in folder [message #662717 is a reply to message #662705] Wed, 10 May 2017 03:27 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
What do you mean by validate the file?
Re: How to check file exist in folder [message #662719 is a reply to message #662717] Wed, 10 May 2017 03:30 Go to previous message
er.surana
Messages: 4
Registered: July 2015
Location: INDIA
Junior Member
to check if file available in folder then pass message
Previous Topic: prevent duplication on the form
Next Topic: frm-40735 error occur with ora-01403
Goto Forum:
  


Current Time: Sat May 30 13:51:24 CDT 2020