Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
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 ?
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 ?
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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
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
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
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 ?
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.
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.
"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.
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.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial