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 - 15:04:13 CEST