Re: Sending events from Oracle to a OCI program!

On 4 Dec 2001 09:59:21 -0800, nickanto_at_netscape.net (Antonio) wrote:

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

You can use the dbms_alert package, or use the advanced queuing mechanism.
Looks like dbms_alert would suffice, and no temp tables needed.

Hth

> Thanx in advance!!!!
>
>
>
>e

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Dec 04 2001 - 12:44:13 CST