Devart Forums

Hi support

I use Delphi 2007
Oracle 10G
Odac professional 6.25.0.12
windows XP SP2
OraSession.Direct := true
OraSession.optimizermode := omFirstRows
All oraquery have NonBlocking = true and FetchAll = true;

In my application i have one session that execute a query and display the resulset into a dbgrid, while the query is Executed i read
the RowsProcessed property and display the download status to the user, the application works great, but when i run other query (needing a long time before return)
on the same session the previous query that was Fetching data is "paused" until the new one ends its run.

How i can avoid this behavior ?

Thanks in advance Paolo

Sorry guys, do you have any news ?

There is no way to do it.

IT's only allowed to have one active query on a session. While one query is executed the other query is locked.

As far as i know, is it an oracle restriction.

Greetings
Jens

Ok

One Session One query ....

Question ?!?

If you look at odac multiquery demo you can see a different behavior why ?

In MultiQuery demo there is query that can be executed fast. But long time is needed to fetch all rows.

In your application the second query needs long time for execute. Other operations cannot be performed while that query is executed. This is an Oracle limitation.

Ok

Thansk for your reply

Hi,

this was the reason for my request:

http://crlab.com/forums/viewtopic.php?t=11023

If this is enabled you have a chance to react on such situations.

Greetings
Jens

jfudickar wrote:Hi,

this was the reason for my request:

http://crlab.com/forums/viewtopic.php?t=11023

If this is enabled you have a chance to react on such situations.

Greetings
Jens

Maybe usefull

By

If you are interested in visual threaded dataset you can also have a look at my jvcl implementation of odac datasets.

With this implementation you get a modal or nonmodal dialog which shows the execution while the fetching is done in the backend thread.

You find it here : http://homepages.codegear.com/jedi/jvcl/

Greetings
Jens

Hi jfudickar

Thans for your suggestion.