See ch. 10 of the PL/SQL programmers guide -- external procedures.
Summary: someone needs to write a DLL that executes the external program,
then Oracle can call the function from the DLL from a PL/SQL procedure.
I've never had the nerve to put that in a procedure, however, but the
context indexing is done that way so it must be possible :-).
"Allen R. Lucas" wrote:
> We have Oracle 8.0.5 in NT4.0.
>
> A developer asked if an Oracle trigger can be used to kick off an
> executable. Looking in my books, I would have to assume 'no' as I find
> noreference to this, but can anyone verify I am wrong, and where could I
> get addiional information if I am wrong?
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Allen R. Lucas
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
begin:vcard
n:Jerman;Don
tel;work:919.508.1886
x-mozilla-html:TRUE
org:Database Management Service,Information Technology
version:2.1
email;internet:[EMAIL PROTECTED]
title:Database Administrator
adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA
x-mozilla-cpt:;-9536
fn:Don Jerman
end:vcard