Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to call a PRO*C program from PL/SQL trigger
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