maria-developers team mailing list archive
Mailing list archive
I come back with a question on functions.
On Oracle, there is only one difference between a function and a stored procedure : the return code.
On Mariadb, stored functions are more limited :
- Recursive stored functions are not allowed
- Explicit or implicit commit is not allowed in stored function
- in out parameter are not allowed (MDEV-10654)
- no dynamic sql (execute immediate)
Have you planned to remove these limits?
If not, we'll have to find the best workarounds to use stored procedures (and find a solution to mimic a return code)