My Oracle Support Banner

ODPU: OracleDataadapter Fails With Automatic Generation Of SelectCommand in 19c (Doc ID 2813350.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Data Provider for .NET - Version 12.1.0.2 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)

Symptoms

ODP.NET application raised ORA-00942: table or view does not exist error when  OracleDataAdapter to fetch the data from more than one table and OracleCommandBuilder objects is used to  updates SelectCommand parameter which is no longer used for automatically constructed DML commands (Insert, Update, Delete)

This issue does not reproduced with  12 ODAC relase 3 and The behavior has been changed from version 4.121.2.0 ODAC RELEASE 4.

Example:

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.