Home » SQL & PL/SQL » SQL & PL/SQL » UTL - Check is file existed (Oracle 8.1.7)
UTL - Check is file existed [message #336130] Thu, 24 July 2008 23:51 Go to next message
Messages: 143
Registered: May 2002
Senior Member
What I'm trying to is -> We are in the midst of implementing a third party recruitment system and we are required to transfer the applicants data back to our Oracle Recruitment System. The third party recruitment system will generate the data in csv/text format. So I have two main tasks here.

One is finding the solution how to read the text/csv files (So, my fidning is use UTL)
Second, study the API in order to load the data into the tables.

My problem now is:
1.) I want to check if the file is existed, then only open an read the file content.
I have read through below UTL's package:

But there has no such function, pls advise.

Re: UTL - Check is file existed [message #336132 is a reply to message #336130] Thu, 24 July 2008 23:58 Go to previous messageGo to next message
Messages: 24963
Registered: January 2009
Location: SoCal
Senior Member
How is it you are using V8, not supported this century?
What you desire is easily done via via PERL & DBI/DBD
Re: UTL - Check is file existed [message #336139 is a reply to message #336130] Fri, 25 July 2008 00:34 Go to previous message
Barbara Boehmer
Messages: 8611
Registered: November 2002
Location: California, USA
Senior Member
Previous Topic: UTL_FILE open file
Next Topic: Date Range
Goto Forum:

Current Time: Tue Oct 25 19:54:01 CDT 2016

Total time taken to generate the page: 0.08990 seconds