Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: get directory lisrting on xe
> No, the advice is incorrect as host is a sqlplus command.
> You'll need external procedures.
Sybrand
I been using the HOST command within Oracle Forms 6.0.8.x for years. Not just sqlplus..
On Mar 30, 4:00 pm, sybra..._at_hccnet.nl wrote:
> On 30 Mar 2007 12:58:29 -0700, "prunoki" <hegyv..._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
Received on Sat Mar 31 2007 - 10:05:25 CDT