My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.