Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: get directory lisrting on xe
can you
use the host command
host('dir *.txt > c:\temp\mylist_of_text.txt',no_screen);
u_in_file := UTL_FILE.FOPEN (file);
loop
UTL_FILE.GET_LINE ( u_in_file ,LINEBUF);
etc
On Mar 29, 7:49 am, "prunoki" <hegyv..._at_ardents.hu> wrote:
> Hello,
>
> I need to write a PL/SQL routine under XE to scan the contents of a
> directory and process the files found there. I used to get the
> directory listing under 8.1.7.4 with Java, which is not included in
> XE. Any ideas how to get a directory list under XE? I searched the
> docs to no avail. One article on asktom suggested using external
> procedures, but I am very low on the learning curve with that right
> now.
>
> Cheers,
>
> Krisztian
Received on Fri Mar 30 2007 - 06:07:44 CDT