I did not try, but I think it should be possible. Everything depends on
settings or recordset. try to play with CursorLocation, CursorType and
LockType properties. Cjheck next link with different samples of connection
strings  (to Oracle as well). That link has examples with different ODBC
drivers and OLEDB providers

http://www.able-consulting.com/ADO_Conn.htm

--
Val Mazur
Microsoft MVP

You will not be able to get a dynamic cursor type for an Oracle database.
Oracle does not allow uncommitted reads (aka dirty reads) and Oracle
implements the "Read Consistency" feature.  The contents of a rowset are
established upon execution of the DML statement, and are guaranteed to be
consistent for the life of the opened cursor (or until the "Snapshot too
Old" error condition)

If you need this behavior, you will have to implement it in your
application.  First, get all other apps to commit often (you will never see
uncommited changes from other sessions/transactions).  Second, create a
timer that will periodically cause your recordset to be closed and then
re-opened.

regards
roy fine