Question on OCIBreak to stop Query

From: Timothy Bish <tabish_at_twcny.rr.com>
Date: 28 Jan 2002 10:25:35 -0800
Message-ID: <1710e62d.0201281025.2348367c_at_posting.google.com>

Hello

    I am trying to write a C++ class that wraps OCI, and uses the DBMS_ALERT package to wait on an event trigger from the DB Server when a change to a specific table takes place. I have everything working except for canceling the OCIExecute once I decide to stop waiting for the event.

    The class creates a separate thread that connects to the DB on it own Context, and Session and it waits using a call to OCIExecute which is executing the following type of SQL

BEGIN DBMS_ALERT.WAITONE(:Event, :Data, :Status, :TimeOut); END;

    I have provided a method for the main thread to call to cancel the OCIExecute() using OCIBreak() which I thought should break the currently running query. However when I call this nothing happens. Does anybody know what I might try to get this working?

I'm running with NT4 sp6, connecting to an Oracle 8.1.7 DB. Compiling with VC++ 6.0 sp5.

---

Timothy A. Bish
Lockheed Martin - NE&SS
Work Email - timothy.a.bish(at)lmco.com

---

Received on Mon Jan 28 2002 - 19:25:35 CET