I am working on a project that handles customer orders and inventory. I am stuck on one part, I keep getting the ORA-02291 error. The column causing the problems is the CustOrderID. Here's what I have:
This statement uses a sequence to create a new CustOrderID
select CustOrder_seq.nextval into l_CustOrderID from dual;
This statement inserts the new CustOrderID into the header:
You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.