Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Help needed with strange constraint problem
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.
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. EisenhowerReceived on Wed Jan 22 1997 - 00:00:00 CST
![]() |
![]() |