How To Read File Path In Oracle

hi
i have oracle form 6i
i want to lookup in a specific directory if a file found or not ( any file , such xls . jpg , txt , mdb ,, etc
what is the suitable code for it ?
NiceMan331Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
The code you had in your other question: http://www.experts-exchange.com/Database/Oracle/Q_28683736.html

Shou0ld work.  You just need to work with your DBA to properly set UTL_FILE_DIR or a better solution depending on your Oracle Database Version is to use Oracle Directories:
http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_5007.htm#SQLRF01207
0
NiceMan331Author Commented:
all my problems is i don't have good touch with our DBA
if any thing i can do myself on my cleint is ok
on the server , they are not happy to take an advice from any other persons
0
NiceMan331Author Commented:
but any how , i would like to understand it
what is the meaning of create directory ?
it says in the document :
A directory object specifies an alias for a directory on the server file
is it means , if i have a file path on my operation system for example :
c:\document\myfile.xls
the create directory , what for example will make it ?
and , should create directory for all paths on operation systems ?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

slightwv (䄆 Netminder) Commented:
The Oracle Directory is a point to an Operating System folder.  It is more secure than the old UTL_FILE_DIR spfile/spfile parameter.

There is an example in the doc link I posted.  There are also examples in the docs for using UTL_FILE and Oracle Directory objects.
0
Mark GeerlingsDatabase AdministratorCommented:
"A directory object specifies an alias for a directory on the server file [system]."

Note that this directory is on the SERVER's file system, and NOT on your local PC's hard drive.  If your database server runs a version of Windows server software, then it may have a directory like: "c:\document".  But no, you cannot use either a logical directory (that can be created with a "create directory..." command) or a physical directory (that must be specified in the UTL_FILE_DIR initialization parameter for the database) for a file on your local PC.

Oracle Forms6 includes a supplied PL\SQL package named: text_io that *CAN* use local files on your PC, but only *IF* you are running Forms6 in client/server mode.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
NiceMan331Author Commented:
Markger , I'm using oracle forms 6i , but I'm a cleint , connecting another server database , also I already installed oracle 11 g on my PC , but my work is on the database on a server , and I need to look for a file if found on my PC or not ( which is images stored in my PC )
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.