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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to run a OS Command from PLSQL ?

Re: How to run a OS Command from PLSQL ?

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Tue, 7 Sep 1999 23:37:13 +0100
Message-ID: <7r40q5$n5f$1@news.inet.tele.dk>


For Oracle7 use something like PLEX
(http://www.oracle.com/database/features/plsql/plexdoc_toc.html). For Oracle8 use the built-in feature External Procedures (http://www.oracle.com/oramag/oracle/99-Jan/19or8.html for UNIX and http://technet.oracle.com/support/scr/content/471/471.htm for Windows NT).

HTH. Finn

Rui Anastácio <coreto03_at_axa-seguros.pt> wrote in message news:7r0m4u$5et$1_at_duke.telepac.pt...
> Hi !
>
> Can I run an Operating System program from a PLSQL program ?
> For example to send a mail:
>
> declare
> email varchar2(50) := 'john_at_home';
> begin
> SYSTEM('mail ' || email || ' < hello');
> end;
>
>
> Note: SYSTEM is the function I'm looking for.
>
> Thanks in advance
> Rui Anastácio
>
>
Received on Tue Sep 07 1999 - 17:37:13 CDT

Original text of this message

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