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 and later
Information in this document applies to any platform.


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.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.