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.



_______________________________________________
Mailing list: https://launchpad.net/~maria-developers
Post to     : maria-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-developers
More help   : https://help.launchpad.net/ListHelp

Reply via email to