Devart Forums

How does one prevent table (or any) locking with ODAC components?
Oracle is Version 8i and all I need is read only access for select statements (i.e. a snapshot).

Basically I'm reading data from Oracle tables populated via a propriatry software package for further data analysis therefore no modification to the existing tables is rquired.

Does ODAC perform table/record locking as default?

BTW, I should mention that I'm using 'Direct' mode if that might make a difference.

ODAC does not lock tables if you don't edit data.

Thanks for the reply Plash.
Thus when the dataset is set to read only there is no possibility of any table or row lock?
Under what conditions does ODAC lock a table (rather than row)?

Basically the third party supplier is saying than my 'accessing' their tables is locking them in some instances - at least they're using it as an excuse that some fields in their tables have not been correctly updated - this going back to 2005 although I only started reading from their tables a year back ...........
The comment was that Oracle 8i locks tables by default when they are accessed.
All I'm doing is 'looking up' stock levels, customer addresses etc from their tables for further processing in my custom aps.

There should be no locks if you only read the data. ODAC never locks whole tables. ODAC can lock a row if you edit it using TOraTable.

Thanks once again Plash.

Just wanted expert confirmation.