Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to cancel a query in Oracle?
Jinqlih Sang <csang_at_home.com> wrote:
>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.
I believe that SqlNet is what is holding the client...I am not sure is SqlNet can be run in a 'non-blocking' mode so what you want may not be possible...Perhaps others have found a way...
Good Luck,
John Greco
Received on Wed Jun 03 1998 - 10:06:48 CDT