OraFAQ Forum: Forms » how to know that file is available or not

Home » Developer & Programmer » Forms » how to know that file is available or not (form 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to know that file is available or not [message #458051]

Thu, 27 May 2010 01:56

pradeepmca1980
Messages: 5
Registered: May 2010
Location: India

Junior Member

Dear all,

please tell me that how to know that any specific file is available in specific folder or not in form6i?

Regards
Pradeep

Report message to a moderator

Re: how to know that file is available or not [message #458057 is a reply to message #458051]

Thu, 27 May 2010 02:34

gregor
Messages: 86
Registered: March 2010
Location: Germany

Member

hi pradeepmca1980 ,
to look for a file, try open the file, catch the exception.
--on Database-Server: You can use database package "UTL_FILE.fopen" ( there are Security limitations to abtain, where to read, before you can use it).
Predefined Exceptions for utl_file.fopen are:
UTL_FILE.INVALID_MODE
UTL_FILE.INVALID_OPERATION
UTL_FILE.INVALID_PATH
UTL_FILE.INVALID_MAXLINESIZE

-- on ApplicationServer: Use the Forms-buildin "TEXT_IO.fopen()"
-- On Client-side: You can use WEBUTIL Client_text_io.fopen. For exceptions see Forms-online-Help.

GG

Report message to a moderator

Re: how to know that file is available or not [message #458058 is a reply to message #458057]

Thu, 27 May 2010 02:47

pradeepmca1980
Messages: 5
Registered: May 2010
Location: India

Junior Member

Thank GG
but i want tell you actual scenario,
I stored the some .bmp/jpg file in one folder like c:\photo\pp.jpg.
In form6i, while pressed button, first i want to search the specific jpg file in c:\photo\ foler. if it is avaliable,then i proceed the next step otherwise i want to stop and give the error message to user. so my problem is , how we can search the file(.bmp/jpg) in c:\photo\ folder in form6i scenario.
please help me
Regards
pradeep

Report message to a moderator

Re: how to know that file is available or not [message #458062 is a reply to message #458058]

Thu, 27 May 2010 03:03

infosuresh2k
Messages: 77
Registered: September 2009
Location: CHENNAI, INDIA

Member

Hi Pradeep,

U can use webutil for 10g or d2kwutil for 6i in this pll we have so many program units are there please check for FUNCTION FILE_EXISTS, this function will give if file exists or not.

Regards
Suresh.V

Report message to a moderator