Re: list contents of directory

  • From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
  • To: "Wojciech Skrzynecki" <wojciech.skrzynecki@xxxxxxxxx>
  • Date: Tue, 19 Sep 2006 11:24:31 +0200

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.


On 9/19/06, Wojciech Skrzynecki <wojciech.skrzynecki@xxxxxxxxx> wrote:

On 9/19/06, Stefan Knecht <knecht.stefan@xxxxxxxxx > 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?


Other related posts: