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: get directory lisrting on xe

Re: get directory lisrting on xe

From: ph <mtnman2k_at_gmail.com>
Date: 30 Mar 2007 04:07:44 -0700
Message-ID: <1175252863.965373.114850@n59g2000hsh.googlegroups.com>


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

Original text of this message

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