Prevent Table Locking

polsol · Post by **polsol** » Thu 21 May 2009 10:12

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?

polsol · Post by **polsol** » Fri 22 May 2009 05:35

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

Plash · Post by **Plash** » Fri 22 May 2009 06:29

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

polsol · Post by **polsol** » Fri 22 May 2009 09:30

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.

Plash · Post by **Plash** » Mon 25 May 2009 08:03

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.

polsol · Post by **polsol** » Mon 25 May 2009 08:52

Thanks once again Plash.

Just wanted expert confirmation.