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: Ronald <_ronr__at__wxs.nl_>
Date: Sat, 11 Apr 1998 15:44:41 +0200
Message-ID: <B1554069966834BB9@ut0241.wxs.nl>


It's not that difficult; just let your trigger write the message to a dbms_pipe. Let a pro*c program read the pipe in a loop (blocking read) and do the work it should do. The dbms_pipe messages are always delivered, it's not waiting for commit or rollback.

>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
>
>

Ronald



mailto:ronr_at_wxs.nl
http://home.wxs.nl/~ronr/RonR.html (last update: dec 31, 1997) Received on Sat Apr 11 1998 - 08:44:41 CDT

Original text of this message

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