| ORA-02292: integrity constraint (SCOTT.FK_orderno) violated [message #35698] |
Sun, 07 October 2001 15:55  |
Adam
Messages: 15
Registered: October 2001
|
Junior Member |
|
|
Can someone help me please.
I keep getting an 'ora' error message when I try to add a record: (ORA-02292: integrity constraint
(SCOTT.FK_ORDERNO) violated child record found).
Basically I add a new 'order', then I add the many 'order_lines'(dishes and/or drinks) associated with that order.
In this case they will become the child records of that one order. The error happens when I want to update the
'order' block, by working out the total price of all the order_lines put together. This happens even though in the Pl/SQL code I do not attempt to update the orderno.
I was wondering if anyone had a resolution to this problem.
----------------------------------------------------------------------
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
