Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Non-blocking SQL statements with Pro*C
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