Update of a Child Entity With ConcurrencyMode=Fixed set on both the Child and Parent Fails with: ORA-06550/PLS-0103 (Doc ID 1459005.1)

Last updated on MAY 17, 2012

Applies to:

Oracle Data Provider for .NET - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

If both the parent and child entities have a column with ConcurrencyMode=Fixed, Entity Framework will attempt to update the parent record whenever the child is modified, even if the parent is not modified.  In this scenario, ODP.NET creates a invalid update statement statement and this fails and returns an exception. The same code is successfully with SQL Server.

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