Re: get directory lisrting on xe

Fuzzy írta:
> On Mar 31, 8:05 am, "ph" <mtnma..._at_gmail.com> wrote:
> > > No, the advice is incorrect ashostis a sqlpluscommand.
> > > You'll need external procedures.
> >
> > Sybrand
> >
> > I been using theHOSTcommandwithin Oracle Forms 6.0.8.x for years.
> > Not just sqlplus..
>
> HOST is a Forms built-in. It is also a SQLPlus built-in. These are
> both application run-time environments.
>
> As far as I know, HOST does not exist in Oracle DB 10g PL/SQL as an
> Oracle-supplied command, which in Oracle XE will natively run in the
> database.
>
> Even more, since HOST will run on the server, it may not have the same
> interpretation as the OP wants ... is the directory to be scanned on
> the server or the client? The original post is not quite definitlve.
>
> Interestingly, Tom Kyte posted a message in this forum in 1997 to give
> an example of how this may be accomplished using DMS_PIPE and C
> program. (http://groups.google.ca/group/comp.databases.oracle.server/
> browse_frm/thread/3f82e58b3aa7125d/7319a9c2923bd70c)
>
> /Hans

The dir to be scanned is on the server. The idea to run a "client program" on the server to let the others issue operating system commands using dbms_pipe is cool. My environment is Windows so I will have to do something like this myself, but since we are partly a PHP shop, this will not be a problem. Thanks a lot for the help!

Krisztian Received on Sun Apr 01 2007 - 14:57:15 CDT