Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help needed with strange constraint problem

Help needed with strange constraint problem

From: Dwayne K. King <dwayne_at_dwayne.FreeNet.Kiev.UA>
Date: 1997/01/22
Message-ID: <ADm1VvoON4@dwayne.FreeNet.Kiev.UA>#1/1

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 Wed Jan 22 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US