Re: How to cancel a query in Oracle?

Hi Jinqlih,

The thing you want is available in OCI and is called non-blocking mode. I am not sure about Pro C.

Andrew Protasov

Jinqlih Sang wrote in message <35755EEA.6332D842_at_home.com>...
>The code in my application is like:
>
>++++++++++++++
>EXEC SQL PREPARE ... (prepare sql statement)
>EXEC SQL DECLARE CURSOR ... (declare a cursor)
>EXEC SQL OPEN ... (open a cursor)
>EXEC SQL DECLARE SELECT LIST FOR sqlCommand INTO SelectDescriptor
> (describe the returned results)
>EXEC SQL FETCH ...USING DESCRIPTOR ... (retrieve the next row)
>EXEC SQL CLOSE ... (close the cursor)
>++++++++++++++
>
>** I wish I can cancel the select statement when Oracle Server has
>been executing (the cursor is open already)
>
>** In another words, I wish Oracle client can pass the sql statement
>to Oracle server, and Oracle server would (could be??) simply
>execute it but return the control to the oracle client so the oracle
>client appliation can still do something else. The client
>can ask Oracle server whether the data is available to fetch or not.
>If Oracle server would return "yes, data is ready." then client
>will start fetching the data.
>
>Does it make sense?
>
>I know SQL Server can do that, I am wondering if Oracle can do that
>or not. It would be helpful if it's a large select, otherwise
>the client can not do anything except waiting.
>
>Thanks.
Received on Thu Jun 04 1998 - 06:24:34 CDT