Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: is it possible to execute a unix command from an oracle procedure?

Re: is it possible to execute a unix command from an oracle procedure?

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: 2000/06/04
Message-ID: <8hei9m$9pr$1@news.inet.tele.dk>#1/1

From Oracle 8.0 you can use External Procedures which is basically the feature that enables calls from PL/SQL to C code in a DLL/.so.

HTH. Finn

Chris Garcia <cegarcia_at_mediaone.net> wrote in message news:OvFZ4.31474$WS3.368624_at_typhoon.we.rr.com...
> Tom,
> I have to execute Unix commands from Oracle too. We're using 8i. What
> package are you talking about? DBMS_PIPES? If so, think there's a lot
 more
> stuff you have to setup for this work. I can't believe Oracle doesn't
 have
> a more straight forward method of doing this sort of thing.
>
> If there is, please let me know.
> Thanks,
> Chris
>
> "Tom Zamani" <tomz_at_redflex.com.au> wrote in message
> news:8h4ajl$5p1$1_at_perki.connect.com.au...
> > oracle 7.X NO, Oracle 8.X Yes.
> > in Oracle 8.1.6 there is a package which is used for external procedure
> > call.
> > Tom
> > NetComrade <andreyNSPAM_at_bookexchange.net> wrote in message
> > news:39358413.95880248_at_news.earthlink.net...
> > > is it possible to execute a unix command from an oracle procedure?
> > > and save it's output in a variable?
> > >
> > > Thanx
> > > ---------------
> > > In case I forgot to mention:
> > > We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes
> > > ---------------
> > > Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630
> > > AOL: NetComrade ICQ: 11340726 remove NSPAM to email
> >
> >
>
>
Received on Sun Jun 04 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US