Non-blocking SQL statements with Pro*C

From: <alam_at_nxt.com>
Date: Tue, 05 May 1998 17:25:58 -0600
Message-ID: <6io3lm$qcb$1@nnrp1.dejanews.com>

Is there any way to setup a non-blocking SQL statement in general? with Pro*C?

I have a process that needs to poll a number of file descriptors (sockets and FIFOs). For each event on the fifos, I have to perform some database operations. I really don't want to be blocked waiting for the query's result while there are other events to be serviced.

I tried to use multi-threaded Pro*C code (Oracle for Workgroup 7.3.3 and Pro*C 2.2.4)to solve the problem, but was not very comfortable with the reliability of the Pro*C generated code in an MT environment.

Thanks.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 05 1998 - 18:25:58 CDT