OraFAQ Forum: SQL & PL/SQL » Can we call a stored function in the constraint of a table?

Home » SQL & PL/SQL » SQL & PL/SQL » Can we call a stored function in the constraint of a table?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can we call a stored function in the constraint of a table? [message #433246]

Mon, 30 November 2009 23:58

priyasinha396
Messages: 15
Registered: November 2009
Location: Delhi

Junior Member

Can we call a stored function in the constraint of a table?

Report message to a moderator

Re: Can we call a stored function in the constraint of a table? [message #433250 is a reply to message #433246]

Tue, 01 December 2009 00:47

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Which kind of constraint?
What happened when you tried?

Database SQL Reference
Chapter 8 Common SQL DDL Clauses
Section constraint
Paragraph Restrictions on Check Constraints

Quote:

...
* Conditions of check constraints cannot contain the following constructs:
...
** Calls to user-defined functions
...

Regards
Michel

Report message to a moderator

Re: Can we call a stored function in the constraint of a table? [message #433346 is a reply to message #433246]

Tue, 01 December 2009 13:38

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

You can allways create a TRIGGER.
Shocked

Report message to a moderator

Re: Can we call a stored function in the constraint of a table? [message #433378 is a reply to message #433346]

Wed, 02 December 2009 00:33

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I think this is just an interview/exam question (see the other questions from the same OP) and just need a direct answer from doc not a workaround.

Regards
Michel

Report message to a moderator

Previous Topic:	isDigit () method in PL/SQL
Next Topic:	datatype for status like columns

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 01:19:50 CST 2024