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

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

From: <sdogiparthy_at_hotmail.com>
Date: Thu, 09 Apr 1998 10:47:10 -0600
Message-ID: <6giqhu$b8a$1@nnrp1.dejanews.com>


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 Thu Apr 09 1998 - 11:47:10 CDT

Original text of this message

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