| Specifying a timeout for a query [message #371662] |
Tue, 21 November 2000 01:22  |
Ian Nowland
Messages: 1
Registered: November 2000
|
Junior Member |
|
|
Is it possible in SQL to specify a timeout which the query must return by with any data retrieved so far?
Basically, some command that could be used along the lines of:
select /*+ timeout 30*/ * from veryLargeTable
So that after 30 seconds the query would return with all the data retrieved so far. I am aware of the where statement "rownum<10000" that can be used to limit the number of rows in the reply, but wish to use the timeout in addition.
|
|
|
|
| Re: Specifying a timeout for a query [message #371673 is a reply to message #371662] |
Wed, 22 November 2000 16:37  |
Andrew again...
Messages: 270
Registered: July 2000
|
Senior Member |
|
|
|
You can specify a limit on the session, but not an individual statement from what I know. In Visual Basic 6 I know that this can be done. I believe it is implemented by the client sending some kill signal to Oracle (equivalent of a cancel or Ctrl-C).
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
