Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Stored Procedure in Check Constraint
In ORACLE, does it work to do the following:
CONSTRAINT CHECK (New.Code IN (SELECT Code FROM StoredProcedure (New.CodeType)))
That is can you have a check constraint that compares the value entered in a column with a list which is returned by a Stored Procedure? The Stored Procedure takes the value from another column in the table as a parameter.
Thanks in Advance
Todd @ COMPASS
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Mon Aug 30 1999 - 10:55:47 CDT