Link to home
Start Free TrialLog in
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 ?
SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of NiceMan331
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
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 ?
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.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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 )