Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Notify C++ prog of update

Re: Notify C++ prog of update

From: Jeffery Cann <jcann_at_fairway.com>
Date: Mon, 24 Aug 1998 11:09:00 -0600
Message-ID: <35E19E2C.4ACAB8B5@fairway.com>


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

Original text of this message

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