- 3,708,735 Users
- 2,241,115 Discussions
- 7,840,563 Comments
Forum Stats
Discussions
Categories
- 9 Data
- 362.2K Big Data Appliance
- 3 Data Science
- 1K Databases
- 322 General Database Discussions
- 3.7K Java and JavaScript in the Database
- 22 Multilingual Engine
- 479 MySQL Community Space
- 3 NoSQL Database
- 7.6K Oracle Database Express Edition (XE)
- 2.7K ORDS, SODA & JSON in the Database
- 408 SQLcl
- 32 SQL Developer Data Modeler
- 184.6K SQL & PL/SQL
- 20.9K SQL Developer
- 1.3K Development
- Developer Projects
- 31 Programming Languages
- 134.5K Development Tools
- 4 DevOps
- 3K QA/Testing
- 172 Java
- 3 Java Learning Subscription
- 6 Database Connectivity
- 64 Java Community Process
- Java 25
- 7 Java APIs
- 141.1K Java Development Tools
- 2 Java EE (Java Enterprise Edition)
- 153K Java Essentials
- 132 Java 8 Questions
- 86.1K Java Programming
- 270 Java Lambda MOOC
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 5 Java SE
- 13.8K Java Security
- 3 Java User Groups
- 22 JavaScript - Nashorn
- 18 Programs
- 80 LiveLabs
- 23 Workshops
- 7 Software
- 3 Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 3 Deutsche Oracle Community
- 6 Español
- 1.9K Japanese
- 2 Portuguese
Net Core 3.1 Beta

If you are going to store a Master-Entry with Detail-Entries by saving the context I got this error:
Innere Ausnahme 1:
OracleException: ORA-02291: Integritäts-Constraint (HR.FK_OrderDetails_Orders_OrderID) verletzt - übergeordneter Schlüssel nicht gefunden
ORA-06512: in Zeile 13
I suppose, that the Detail-Entry is stored before the Master-Entry is. With EF6 same code works fine.
Best Answer
-
user606112 Posts: 9
Hi Alex, I never used Net Core before. I startet with Core 3.1 Beta. I'm sorry, but I found the mistake. I changed my Code using the reference of the navigation column instead of foreignkey column as you can see below. Now it works pretty good.
new version:
if (viewOrderDetails.IsAddingNew & orderdetail.Order == null)
{ // Neuanlage Bestellposition
context.OrderDetails.Add(orderdetail);
orderdetail.Order = order;
} // if
old version:
if (viewOrderDetails.IsAddingNew & orderdetail.OrderID == 0)
{ // Neuanlage Bestellposition
context.OrderDetails.Add(orderdetail);
orderdetail.OrderID = order.OrderID;
} // if
Unfortunatly the old version works without error using EF6. I dont know why? The foreignkey of the detail entry gets a zero value from the primary key of the new master entry. And by saving the context the primary key get's a none-zero value from a sequence, so that the error occurs.
With kind regards! Günter Hoormann
0
Answers
Did the error also occur with Oracle EF Core 2.x or is this the first time you've ported an Oracle app to EF Core?
Hi Alex, I never used Net Core before. I startet with Core 3.1 Beta. I'm sorry, but I found the mistake. I changed my Code using the reference of the navigation column instead of foreignkey column as you can see below. Now it works pretty good.
new version:
if (viewOrderDetails.IsAddingNew & orderdetail.Order == null)
{ // Neuanlage Bestellposition
context.OrderDetails.Add(orderdetail);
orderdetail.Order = order;
} // if
old version:
if (viewOrderDetails.IsAddingNew & orderdetail.OrderID == 0)
{ // Neuanlage Bestellposition
context.OrderDetails.Add(orderdetail);
orderdetail.OrderID = order.OrderID;
} // if
Unfortunatly the old version works without error using EF6. I dont know why? The foreignkey of the detail entry gets a zero value from the primary key of the new master entry. And by saving the context the primary key get's a none-zero value from a sequence, so that the error occurs.
With kind regards! Günter Hoormann