Devart Forums

Hi,

Is there a way in ODAC to abort a Query? I used to use DOA and you could kill a query at the DB Component level. Is there a similar way in ODAC (and SDAC) to do this?

Thanks,

Kevin

You can use BreakExec method to break execution of the SQL statement.

So, if the user selects a big query over a slow line, and the slow retrieval of records starts, can you still call BreakExec?

In testing, I have been receiving access violations and occassional 12612 errors.

Thanks.

You must know that BreakExec functionality is not supported with Net option, pls. see Net option limitations in "Working with ODAC Net" topic of ODAC help.

I was using OCI, not NET option.

Pls. specify your ODAC, Oracle and IDE versions.
Try to reproduce your problem with one of the supplied ODAC demo projects, for example - Query demo. You also must keep in mind that BreakExect should be combined with NonBlockin mode, otherwise the main process would be blocked for execution time, and you will not be able to interrupt query execution.
In case of problem stays pls. send us small demo project that demonstrates your problem and include scripts to create server objects.

Delphi 6, sp2, OCI, non-blocking mode, using your Multi Demo.

Sorry, but we couldn't reproduce your problem, may be we are using BreakExec in different way than you, because there is no any BreakExec functionality in supplied MultiQuery or MultiCursors demo projects. Pls. specify your ODAC and Oracle client/server versions, OS version and send us small demo project with scripts to create server objects to ODAC support address.

Why isn't the BreakExec method supported for the NET option?

'Cause that's what I'm using ...
--
Martijn Tonies
Upscene Productions

Now we do not support BreakExec with Net option. We are planning to add its support in the future.

We are planning to add its support in the future

Sure hope you can add it for the next release.

I assume this would explain the weird errors I've been getting when using Break with the NET option.

One other quick question with regard to cancelling statements --

You stated that you need to execute the query in NonBlocking mode. Would it also be possible to execute it in "simple" standard mode, but in a different thread (not the application mainthread) so you're handling the threading yourself?

Thanks.

--
Martijn Tonies
Upscene Productions

You can execute BreakExec in standard mode in a different thread.