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