Re: PL/SQL and OS(UNIX) calls

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Sun, 30 May 1999 16:33:48 +0100
Message-ID: <7iri8r$7no$1@news.inet.tele.dk>

Ron Reidy <rereidy_at_uswest.net> wrote in message news:374F7EA0.9ED82C2B_at_uswest.net...
>
>
> smfrank_at_my-deja.com wrote:
>
> > Is it possible to send commands to the operating system from a PL/SQL
> > package? I want to be able to call SQL*Loader from a package using the
> > command line arguments.
> >
> > Any input would be greatly appreciated,
> > Shawn Franklin
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
>
> You will need to write a daemon (in C, Perl, whatever) and use DBMS_PIPE
to
> listen for requests.
>
> --
> Ron Reidy
> Oracle DBA
> Reidy Consulting, L.L.C.
>
>

I've built exactly that interface for Oracle 8.0 using External Procedures. In Oracle7 you would have to use something as written above, eg PLEX (http://www.oracle.com/database/features/plsql/plexdoc_toc.html).

HTH. Finn Received on Sun May 30 1999 - 10:33:48 CDT