I'll bet you have a foreign key constraint on VEH_CODE and
PE406 is not in that table.
just a guess.
Mike
<ben_knill_at_hotmail.com> wrote in message
news:tcm8etj10768cb_at_corp.supernews.com...
> I keep getting this error message but the error is on the table name,
> which is what I don't understand.
>
> ERROR at line 1:
> ORA-02291: integrity constraint (BKNILL.SYS_C007098) violated - parent key
> not
> found
>
>
>
>
> SQL> describe vehicle;
> Name Null? Type
> ------------------------------- -------- ----
> VEH_REG NOT NULL VARCHAR2(9)
> VEH_CODE VARCHAR2(5)
> VEH_RATE NUMBER(10,2)
>
> SQL> INSERT INTO VEHICLE (Veh_reg,veh_code,veh_rate) values
> ('&Vehicle_registrat
> ion_number','&Model_code',&Daily_rate);
> Enter value for vehicle_registration_number: W345 YRR
> Enter value for model_code: PE406
> Enter value for daily_rate: 20.00
> old 1: INSERT INTO VEHICLE (Veh_reg,veh_code,veh_rate) values
> ('&Vehicle_regis
> tration_number','&Model_code',&Daily_rate)
> new 1: INSERT INTO VEHICLE (Veh_reg,veh_code,veh_rate) values ('W345
> YRR','PE4
> 06',20.00)
> INSERT INTO VEHICLE (Veh_reg,veh_code,veh_rate) values ('W345
> YRR','PE406',20.00
> )
> *
> ERROR at line 1:
> ORA-02291: integrity constraint (BKNILL.SYS_C007098) violated - parent key
> not
> found
>
> --
> Posted via CNET Help.com
> http://www.help.com/
Received on Wed Apr 04 2001 - 17:56:38 CDT
