maria-developers team mailing list archive

[jerome brauge <j.brauge@xxxxxxxxxxx>]

Hello,

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)

Best regards,
Jérôme.