CREATE OR REPLACE PACKAGE lic.mytools AS

  FUNCTION gettest(atext INT) RETURN INT;

END;

CREATE OR REPLACE PACKAGE BODY lic.mytools AS

  FUNCTION gettest(atext INT) RETURN INT AS

    nSalary DECIMAL(10,2);

  BEGIN

    RETURN 111;

  END;

BEGIN

  -- This code is executed when the current session

  -- accesses any of the package routines for the first time

  -- log(0, 'Session ' || connection_id() || ' ' || current_user || ' started');

END;

use lic

select mytools.gettest(123) from dual;

--> 111

select lic.mytools.gettest(123) from dual;

--> SQL Error [1064] [42000]: (conn:16) 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 '(123) from dual

Query is : select lic.mytools.gettest(123) from dual