In the ORACLE-Mode there is a problem to call function and procedure in packages.
Generate the samples
Following run correct:
But when you call it with
then came the error:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.fun_test' at line 1
create is this problem when you are in an other Schema
There I get the same error.
I "quick and dirty" solution is:
Generate a normal function or procedure e.g. "prc_test" in the shema "temp" and in this is the call-statement "call pck_test.fun_test;". Then you can call in the Schema "test" the Function/Procedure "prc_test" in the schema "temp".