Avatar of NiceMan331
NiceMan331
 asked on

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 ?
Oracle DatabaseInfoPath

Avatar of undefined
Last Comment
NiceMan331

8/22/2022 - Mon
SOLUTION
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
NiceMan331

ASKER
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
NiceMan331

ASKER
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 ?
slightwv (䄆 Netminder)

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.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ASKER CERTIFIED SOLUTION
Mark Geerlings

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
NiceMan331

ASKER
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 )