Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Re : UTL_FILE
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