Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to run a OS Command from PLSQL ?
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