Re: Help needed with strange constraint problem

"Dwayne K. King" <dwayne_at_dwayne.FreeNet.Kiev.UA> wrote:
>Hi.
>
>I am having a very weird problem with a stored procedure. The procedure returns
>a BOOLEAN. Running it from SQL*Plus (many times) generates the expected behaviour.
>The procedure is fairly complex and uses dynamic sql to enable and disable
>constraints as it goes.
>
>The problem is this. Under Plus, all works perfectly. However, when I call
>it from a form (using exactly the same syntax), it craps out and generates
>a "form raised unhandled constraint ORA-2298 ..." message. This is the famous
>Unable to ENABLE constraint exception.
>
>Two questions.
>
>1) how can I see _which_ constraint
>2) why is this even happening? Three people have looked at this with me and
>walk away shrugging. Same parameters, same data, one way works, one way fails.
>
>I am at my wits end with this one, so any help is appreciated.
>

Dwayne,

I don't know what your code looks like but if you are disabling and enabling the constraints one at a time put a dbms_ouput.put_line line in your code for each of the constraints and you'll be able to see which constraint is giving you the problem.

Also ORA-2298 indicates that your parent keys are not found, thus the table has orphaned child records I don't know how that fits in with you form as I have not used Oracle Forms.

Good Luck

Nevin Hahn - DBA UCHSC Cancer Center Received on Thu Jan 23 1997 - 00:00:00 CST