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: prunoki <hegyvari_at_ardents.hu>
Date: 30 Mar 2007 12:58:29 -0700
Message-ID: <1175284709.301641.52100@d57g2000hsg.googlegroups.com>

ph írta:
> 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
>

Seems to be a good idea first, but it seems to me that host is actually a command you can execute at the SQL prompt only and you cannot compile it and use it.... Am I missing something here? Received on Fri Mar 30 2007 - 14:58:29 CDT

Original text of this message

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