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: How to call a PRO*C program from PL/SQL trigger

Re: How to call a PRO*C program from PL/SQL trigger

From: Donne You <dy_at_gomez.physics.lsa.umich.edu>
Date: Sat, 11 Apr 1998 04:52:44 GMT
Message-ID: <wGCX.709$ME2.3328321@news.itd.umich.edu>


Read up on Oracle8's call-out capabilities. It allows you to load and execute external shared libraries through a call-out listener. I have tested this in Procedures and functions. It may work in triggers as well.

>Hi,
> Any one please help me, my question is "HOW TO CALL A PRO*C PROGRAM FROM A
>PL/SQL TRIGGER?
>
> I am doing a project named database email link, there will be two sets
>of same databases in two servers, one database can be updated by user, so
>whenever there is a change in that database, the trigger should fire and it
>should call a PRO*C program which will send a mail to the other server
>mentioning the changes in this database. The other server will have another
>PRO*C program which reads and analyzes the mail and changes the second
>database automatically. This is the specification,
> PLEASE TELL ME THE PROCEDURE TO CALL PRO*C PROGRAM FROM PL/SQL TRIGGER..
>thank u,
>sreedhar Dogiparthy
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Fri Apr 10 1998 - 23:52:44 CDT

Original text of this message

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