Why the Stored functions cannot called from DML statements?

Questions by vijay.akki

Showing Answers 1 - 3 of 3 Answers

gemini burj

  • Oct 23rd, 2007
 

DML  statement means update, insert or delete.

I tried with update and its work...
Pls try again and if you have a problem let me know with the example.

  Was this answer useful?  Yes

raji_4u

  • Sep 19th, 2008
 

Who says we cannot?

We can call stored functions from DML statements but follow some rules


The rules:
----------
1. Function should use only IN parameter mode. Don't use OUT or IN OUT mode.
2. Functions used in Select statements should not update database tables, where as others can update database.

  Was this answer useful?  Yes

Ayush.sh

  • Mar 31st, 2009
 

To add in above mentioned constraints for using functions in DML statements:
- Called function should not end a transaction

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions