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