Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Notify C++ prog of update
I have successfully used DBMS pipes to send data from the database to a
C program process (a UNIX daemon). My stored procedure will then
register for an alert. After the C program process is finished, it will
trigger the alert and send back data via the DBMS pipe.
Overall, I found the DBMS pipe implementation useful. The only thing I didn't like about it is VARCHAR is the only datatype allowed to be packed into a DBMS pipe (PL-SQL 2.3, Oracle 7.3.3). Maybe Oracle has updated this in Oracle 8, but I haven't worked with O8 yet.
Jeff
JohnRonan_at_worldnet.att.net wrote:
>
> I need to notify one or more C++ programs when a certain table changes.
> Is DBMS Pipes (w/presumably embedded SQL on the C++ side) the way to go or
> is there a simpler way to do this?
> Any advice is appreciated.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
--
Jeffery Cann
Fairway Systems, Inc.
Senior Software Engineer
Received on Mon Aug 24 1998 - 12:09:00 CDT
![]() |
![]() |