Recordset.Update Fails With Error ORA-00942 Using 12c Oracle ODBC Driver

(Doc ID 2232498.1)

Last updated on MARCH 01, 2017

Applies to:

Oracle ODBC Driver - Version and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)


Modifying the existing record in recordset using function Recordset.Update fails with error ORA-00942. The same code works fine when table name is surrounded with double quotes (" ").

Error stack:



Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms