Comments - CREATE PACKAGE BODY
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
I got it :)
SET sql_mode=ORACLE; DELIMITER $$ CREATE OR REPLACE PACKAGE TEST_PKG AS FUNCTION getAnnualSal(eno INT) RETURN DECIMAL(10,2); PROCEDURE raiseSalary(eno INT, amount DECIMAL(10,2)); END TEST_PKG; $$
----------------------------------------------------------------------------------- SELECT TEST_PKG.getAnnualSal(7788); call TEST_PKG.raiseSalary(7788,10); -----------------------------------------------------------------------------------