Windows Oracle Data Access Components (MOSC)

MOSC Banner

Oracle Managed Data Access Bulk Copy Error pasing insert statement for table (virtual columns)

edited Jan 12, 2021 12:11PM in Windows Oracle Data Access Components (MOSC) 2 commentsAnswered

Hi,

We've recently moved to use Oracle.ManagedDataAccess in our application now it supports Bulk Copy. The problem is it seems to have a hard time dealing with tables that have virtual columns where the unmanaged client did not.

Oracle.ManagedDataAccess.Client.OracleException: 'ORA-02373: Error parsing insert statement for table SFOL.BUILDRECORD.

ORA-54013: INSERT operation disallowed on virtual columns'

The specific error above seems to suggest that it doesn't like the DataTable provided but the DataTable clearly specifies the columns and does not include any virtual columns. The underlying table itself does have virtual columns but we're not inserting into them.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center