Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to cancel a query in Oracle?

Re: How to cancel a query in Oracle?

From: TurkBear <johng_at_mm.com>
Date: Wed, 03 Jun 1998 15:06:48 GMT
Message-ID: <35766623.4946092@news2.mm.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US