ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invoking a C# Component from a trigger

388801Feb 26 2003 — edited Mar 2 2003

Hi,

I am interested in finding out if it is possible to access a C# object from within a trigger. I have a number of tables that contain fairly static information that I want to cache in a DataSet on the client machine to minimize the number of connections and database round trips. However, I need to know if the information in the table changes. I've got a basic CachedTable component working using the dbms_alert package (signal, register, waitone) but this requires an open connection to invoke the dbms_alert.waitone procedure to catch the signal (generated in a (IUD) trigger).

If I could invoke a C# method from the trigger then I could come up with some message based way to notify the client objects of the change in the table.

Thanks in advance,

Mike

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 30 2003

Added on Feb 26 2003

#odp-net

2 comments

678 views