How to cancel a query in Oracle?

From: Jinqlih Sang <csang_at_home.com>
Date: Wed, 03 Jun 1998 14:32:07 GMT
Message-ID: <35755F20.7ACD223_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 Wed Jun 03 1998 - 16:32:07 CEST