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.