Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 13729 invoked from network); 19 Sep 2006 03:46:48 -0500
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by 69.64.49.119 with SMTP; 19 Sep 2006 03:46:48 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A73F94288B0;
 Tue, 19 Sep 2006 04:46:19 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 03567-02; Tue, 19 Sep 2006 04:46:19 -0400 (EDT)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2182D4287FF;
 Tue, 19 Sep 2006 04:46:19 -0400 (EDT)
Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 19 Sep 2006 04:45:24 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5ABA1428754
 for <oracle-l@freelists.org>; Tue, 19 Sep 2006 04:45:24 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 03398-03 for <oracle-l@freelists.org>;
 Tue, 19 Sep 2006 04:45:24 -0400 (EDT)
Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.229])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 29BA74284E2
 for <oracle-l@freelists.org>; Tue, 19 Sep 2006 04:45:24 -0400 (EDT)
Received: by wx-out-0506.google.com with SMTP id r21so4975283wxc
        for <oracle-l@freelists.org>; Tue, 19 Sep 2006 01:45:52 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=r4b1aJW3950Gy4ATP4ZU/7Uw/rhahUlakGnCcZgAxxvbOHx/dKM1n3jx+as11nTpCPwsPNF0wi//9+jPccJHrFh0Z2g/omAoaSpoDKuf7z1LuxLQD1afyf+vIOWXiw5Dj/BDsBTpCLonJIogyLaBSIiMQO6ZAh/TAcndlbUUP8Q=
Received: by 10.90.25.3 with SMTP id 3mr5130574agy;
        Tue, 19 Sep 2006 01:45:51 -0700 (PDT)
Received: by 10.90.55.18 with HTTP; Tue, 19 Sep 2006 01:45:51 -0700 (PDT)
Message-ID: <486b2b610609190145g746f14b3u10d28d46964c839c@mail.gmail.com>
Date: Tue, 19 Sep 2006 10:45:51 +0200
From: "Stefan Knecht" <knecht.stefan@gmail.com>
To: wojciech.skrzynecki@gmail.com
Subject: Re: list contents of directory
Cc: oracle-l <oracle-l@freelists.org>
In-Reply-To: <e44afebe0609190131y2abd6032yc31f7a1ce611fe11@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_84400_23360167.1158655551470"
References: <e44afebe0609190131y2abd6032yc31f7a1ce611fe11@mail.gmail.com>
X-archive-position: 39596
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: knecht.stefan@gmail.com
Precedence: normal
Reply-to: knecht.stefan@gmail.com
X-list: oracle-l
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net
------=_Part_84400_23360167.1158655551470
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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



On 9/19/06, Wojciech Skrzynecki <wojciech.skrzynecki@gmail.com> wrote:
>
> I have question about directory which is created by command: "create
> directory ....."
>
> Is it possible to list contents of directory from sql. If yes could you
> give me answer.
>
> Thanks for help.
>
>
> --
> Wojciech Skrzynecki
> Database Administrator
>

------=_Part_84400_23360167.1158655551470
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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.<br><br>Stefan<br><br><br><br><div><span class="gmail_quote">
On 9/19/06, <b class="gmail_sendername">Wojciech Skrzynecki</b> &lt;<a href="mailto:wojciech.skrzynecki@gmail.com">wojciech.skrzynecki@gmail.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>

<p><span style="font-family: Arial;" lang="EN-US">I have question
about directory which is created by command: &quot;create directory .....&quot;</span></p>



<p><span><span style="font-family: Arial;" lang="EN-US">Is
it possible to list contents of directory from sql. If yes could </span></span><span style="font-family: Arial;" lang="EN-US">you give me
answer.</span></p>



<p><span lang="EN-US">Thanks for help.</span></p></div><div><span class="sg">

<br clear="all"><br>-- <br>Wojciech Skrzynecki<br>Database Administrator

</span></div></blockquote></div><br>

------=_Part_84400_23360167.1158655551470--
--
http://www.freelists.org/webpage/oracle-l