Re: Help!!!

From: Vladimir M. Zakharychev <bob--nospam--_at_dynamicpsp.com>
Date: Thu, 11 May 2006 14:18:07 +0400
Message-ID: <e3v313$2rhc$1_at_hypnos.nordnet.ru>

"Wallace" <princevictor.moses_at_gmail.com> wrote in message news:1147342003.621500.248390_at_q12g2000cwa.googlegroups.com...
>
> but it is telling
> " ORA-02291: integrity constraint (PRINCE.UD_COSA_FORMAL_FK2)
> violated - parent key not found
> ORA-06512: at "PRINCE.PROC_COSA", line 9
> ORA-06512: at line 2 "
>
>
> UD_COSA_FORMAL_ID is the primary key...
> What is the problem?
>
The error message described you the problem in detail, didn't it? You have a foreign key constraint and your insert inserts data for which no parent key exists. You need first populate the master table which UD_COSA_FORMAL_FK2 references and then insert detail data.

-- 
   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)
   http://www.dynamicpsp.com

Received on Thu May 11 2006 - 12:18:07 CEST

This message: [ Message body ]
Next message: Mark C. Stock: "Re: What is the problem with this stored procedure?"
Previous message: Wallace: "Help!!!"
In reply to: Wallace: "Help!!!"
In reply to Wallace: "Re: What is the problem with this stored procedure?"
Next in thread: Mark C. Stock: "Re: What is the problem with this stored procedure?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message