Re: Triggering external applications - Oracle 8 / Solaris 2.6

From: Scott Cote <scottcotexy_at_contractor.net>
Date: Mon, 27 Jul 1998 12:21:41 -0500
Message-ID: <35BCB725.84878076@contractor.net>

Russell,

You need to write an external procedure. Look at the Oracle 8 documentation for the "CREATE PROCEDURE ..." syntax.

external library [user.]library_name

    [name external_proc_name]
    [language language_name]
    [calling standard [c / pascal]

    parameters (external_parameter_list) [with context]

the create library command:

create library THE_LIB as '/oracle/thelib.so';

creates a library pointing to the library file called /oracle/thelib.so .

Don't forget about granting execute privilege to the library.

SCott

Russell Fray wrote:

> Hi,
>
> Could somebody tell me how I can write a table trigger which invokes a
> procedure and/or then is also able to call an external application?
>
> I am running Oracle 8.0.4.0.0 under Solaris 2.6 and need to be able to
> run an external C program, which is passed variables from a procedure,
> which is triggered using a trigger on a table.
>
> Please CC replies to 'russ_at_u-net.net' if possible.
>
> It would be very good if somebody could just point me to an
> appropriate URL which explains the above!
>
> Thanks very much in anticipation.
>
> Best Regards,
> Russell.

Received on Mon Jul 27 1998 - 12:21:41 CDT