Sending events from Oracle to a OCI program!

From: Antonio <nickanto_at_netscape.net>
Date: 4 Dec 2001 09:59:21 -0800
Message-ID: <3604814d.0112040959.26b6f198@posting.google.com>

Hello everybody...

I am migrating from an interbase DB to oracle 8i (8.1.7). Migration goes well ... all is migrated for now ... Database, triggers, views, stored procedures ... ( thanx to Thomas Kyte and his Expert One-on-one )

Then ...
I have several programs in C that accesses to Database ... I have migrated them too with OCI Oracle ... (uffffffffff!!!) All goes well, but in some of these programs, there is a "feature" that make the next:

Program is written in Embbeded SQL for Interbase, and in this "C" program there is an instruction: "WAIT EVENT E" that waits until the event "E" is sent by the Interbase Database. The interbase DB send this event after doing something in a trigger ... with "POST EVENT E" And the program continues his procees normaly.

Is there any way to do it with Oracle .. or must I have to implement some kind of events whit a temp table i.e. ?

Thanx in advance!!!!

e Received on Tue Dec 04 2001 - 11:59:21 CST