Re: list contents of directory

It's possible in Oracle9i as well, but you need to have the JServer installed in the database, and use Java to do the directory listing.

As far as I know, it's the same in Oracle 10. The only related thing that 10g offers anew, is the possibility to call OS commands directly from PL/SQL, using DBMS_SCHEDULER package. But the Problem there is that you can't capture the output of the process, hence i.e. a dirlist can't be read directly from PL/SQL.

If you want to run it inside the database, you'll have to use Java, or as Niall suggested, external procedure calls. Though Java might be easier to set up and get going - as there's ready-made examples on the web.

Stefan

On 9/19/06, Wojciech Skrzynecki <wojciech.skrzynecki_at_gmail.com> wrote:
>
>
> On 9/19/06, Stefan Knecht <knecht.stefan_at_gmail.com > wrote:
> >
> > Using SQL or PL/SQL it's not possible. The only way I'm aware of to do
> > this from inside the database is JAVA. Search asktom, it's got a
> > comprehensive example how to do this.
> >
> > Stefan
> >
> >
> >
> > Currently I use Oracle 9. Is it true that in Oracle 10G it is
> possibile to list directories content?
>
> Wojtek
>
>
>

--
http://www.freelists.org/webpage/oracle-l