Help!!!
Date: 11 May 2006 03:06:43 -0700
Message-ID: <1147342003.621500.248390_at_q12g2000cwa.googlegroups.com>
Hai...
I am able to get a collection of rows using BULK COLLECT INTO.
When i try to insert this collection into another table as follows
" "INSERT INTO XPRS$UD_COSA_FORMAL_T(UD_COSA_FORMAL_ID,
COSA_FORMAL, KORT_BETEGNELSE, BETEGNELSE, STARTDATO, SLUTDATO,
UGYLDIG_JN, UDTREK_ID, OPDAT_BRUGER, OPDAT_DATO,
XPRS$UD_COSA_FORMAL_T.VERSION) VALUES(collections(i).COSA_FORMAL_ID,
collections(i).COSA_FORMAL, collections(i).KORT_BETEGNELSE, collections(i).BETEGNELSE, collections(i).STARTDATO, collections(i).SLUTDATO, 'N', 0, collections(i).OPDAT_BRUGER, collections(i).OPDAT_DATO, 0); "
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?
Thanx in advance...
Looking forward for the response.. Received on Thu May 11 2006 - 12:06:43 CEST