Devart Forums

hi odac team,


My question is very simple, is possible with the ODAC prevent the continuous blocks in the APP when his open a SQL query using NonBlocking = true?

Please try you with this simple SQL and send me the result:

select *
from all_users,all_constraints,all_cons_columns,all_apply_error,
all_apply_table_columns,all_tab_columns,all_tab_comments


I have a open support ticket for this issue for some time and not have any answer of the last four emails. besides your email server in some moment send a error message (Failed Recipient: [email protected]).

===================
Ticket ID: 10852
Department: Dac Team
Priority: Medium
Status: On Hold

Regards,
Peter

hi,

Any comment or suggestion?

Regards,
Peter

We have answered you by mail. Here is the answer:
It is a known behavior of Oracle 8 Client. There are two global variables, OCIThreaded and OCIMutexed, declared in modue OraCall. By default they are set to True. You can set them to False in initialization section of your main unit. This will solve the problem but can cause other errors.

Hi Challenger,

Thanks for answer...

The last week I try your recommendation but the problem remain. I use OCIThreaded := false; OCIMutexed := false; but I got the same problem, when execute a SQL the app is freeze.

I test with a SQL that freeze the application for 7 minutes and other SQL's works well.

This is the only way to solve this problem? The are other way to solve this freeze problem with some SQL's ?

Regards,
Peter

Hi Challenger,

I have a question, this problem affect too the NET connection type?

I try the same SQL using the net option and the result is the same that I use the OCI connection.

The are other way to solve this freeze problem with some SQL's ?

Regards,
Peter

Hi,

Any suggestion to avoid this problem?

Regards,
Peter

Can you send us the script to create server objects that are used in a problem SQL statement?

Same problem.
Seems like NonBlocking works only for statement executing, whereas main thread sleep(visually) while fetchin data.
dataset isnt connected to any controls as a datasource, btw
ODAC 6.90.0.52