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 12.1.0.2 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)

Symptoms

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:

 

Cause

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