Re: Help needed with strange constraint problem

What version of Oracle? In early versions of Oracle7, occasionally if you had statistics on a table, the add constraint stmt would give a similar error. The other thing that comes to mind is verifying the order of the enable constatint stmts. Maybe and order by on your query that generates the constraint stmt? Just a thought.

Russ russ.eberle_at_born.com

"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.
 

>TIA
>--
>Dwayne K. King | "Things are more like they are now than
>Computer Systems Advisor, | they ever were before." -
>International Monetary Fund | Dwight D. Eisenhower
Received on Thu Jan 23 1997 - 00:00:00 CST