Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Re : UTL_FILE

Re: Re : UTL_FILE

From: damorgan <damorgan_at_exesolutions.com>
Date: Fri, 29 Nov 2002 18:38:11 GMT
Message-ID: <3DE7B40E.BF2D2E82@exesolutions.com>


s Lehaire wrote:

> Hi !
> I've made a proc which can read a file and put the data in a table.
> Now I've got a problem to access sub-directory in my init.ora
> I put utl_file_dir = C:\testfile and it worked
> but now I put utl_file_dir = C:\dev\client\* because I have to access
> different repertory in C:\dev\client\
> for example C:\dev\client\soci_10\upload or C:\dev\client\soci_20\upload
> where there's a file uploaded by java.
>
> So can I do this ?
>
> thx for rehelp =)

No. You need to specify each directory individually.

utl_file_dir = C:\dev\client
utl_file_dir = C:\dev\client\sub1
utl_file_dir = C:\dev\client\sub2

Just stack up the utl_file_dir statements one after the other.

Daniel Morgan Received on Fri Nov 29 2002 - 12:38:11 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US