Re: get directory lisrting on xe

On 30 Mar 2007 12:58:29 -0700, "prunoki" <hegyvari_at_ardents.hu> wrote:

>
>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?

No, the advice is incorrect as host is a sqlplus command. You'll need external procedures.

-- 
Sybrand Bakker
Senior Oracle DBA