Re: Urgent: Timeout on queries

Without server administrative access (to set user profiles) you will need to do the time-out checking within your app. There are no SQL parameters that you can use to time-out a query.

David P.

Oracle Certified DBA.

Klaus Sparrer wrote:
>
> Hi,
>
> as I need to guarantee a response within a given time I need to know a
> way to limit the time a query consumes to e.g. 30 seconds. The desired
> result is either the requested data (within the given time) or a timeout
> error message.
> Is there a way to implement this without having administrative access,
> i.e. via additional parameters.
> The application accesses the database via Embedded SQL, the database
> version is 7.3.4.
>
> TNX
>
> Klaus++
Received on Wed Apr 05 2000 - 15:07:24 CDT