Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: -2291 (minus num) Error inserting - Please Help !
ORA-02291 integrity constraint str.name violated - parent key not found
Cause An attempt was made to INSERT or UPDATE a foreign key value. The
result was a value that is not in the parent key.
Action UPDATE to or INSERT a value that is in the parent key.
Copyright (C) 1998, Oracle Corporation
jason escribió en mensaje <7pbm5r$v0u$1_at_trinitech.demon.co.uk>...
>Hi,
>I have this stored function which works in some cases and not in others,
>depending on the values passed from VB. On the cases were it's erroring,
the
>SQLCODE is (a minus number) -2291. To try and get the message, I'm running
>the Fn from SQLPlus and have coded the following into the Fn :
>
>dbms_output.put_line (sqlerrm);
>
>At run-time I set serveroutput to on; the return value is printing (the
>sqlcode) but the sqlerrm is not.
>
>Can anyone help me with this, or suggest where I could fins a description
to
>the -2291 error I'm getting ?
>TIA
>Jason
>
>
Received on Tue Aug 17 1999 - 08:04:13 CDT