Re: v7 triggers and OCI

white_at_titan.tsd.arlut.utexas.edu (Eric White) writes:
|> I just received the v7 distribution for SunOS and I've begun to plow
|> through the manuals. One thing I cannot find easily, nor piece together
|> quickly, is how to combine the utility of triggers with an OCI-based
|> application.
|>
|> What are the, general, steps I'd need to take to build an OCI program
|> that had triggers notify it when something in a table changed?

You may want to explore using the pipes services provided by PL/SQL. They are documented online in the dbmspipe.sql file under $ORACLE_HOME/ rdbms/admin in the 7.0.12 release.

Basically, the trigger on the table can write to a pipe, and your OCI program would make the PL/SQL calls to read from the pipe.

Hope this is what you are looking for.

Roderick Manalac
Oracle Corporation
[DISCLAIMER: Posting on my own time with my own information] Received on Wed Feb 24 1993 - 03:46:07 CET