SET SQL_MODE=ORACLE;

CREATE DATABASE IF NOT EXISTS test;

CREATE DATABASE IF NOT EXISTS test2;

USE test

delimiter //

CREATE OR REPLACE PACKAGE pkg1

AS

   FUNCTION func1() RETURN INTEGER;

   PROCEDURE proc1();

END

//

CREATE OR REPLACE PACKAGE BODY pkg1

IS

   FUNCTION func1()

   RETURN INTEGER

   IS

   BEGIN

      RETURN 1;

   END;

   PROCEDURE proc1()

   IS

   BEGIN

      SELECT 2;

   END;

END

//

delimiter ;

SELECT pkg1.func1();

CALL pkg1.proc1;

USE test2

SELECT test.pkg1.func1();

CALL test.pkg1.proc1();