CREATE PROCEDURE P3.CUST_CRT
(IN custName varchar(15), IN custGender char(1), IN custAge int, IN custPin int, OUT custID int, OUT sqlcode varchar(3), OUT err_msg varchar(64))
LANGUAGE SQL
  BEGIN
    DECLARE SQLSTATE CHAR(5);

    INSERT INTO P3.Customer(Name, Gender, Age, Pin) values (custName, custGender, custAge, p3.encrypt(custPin));

    DECLARE custIDCursor CURSOR FOR
    SELECT ID FROM P2.Customer
      ORDER BY ID DESC
        FETCH FIRST 1 ROWS ONLY;

	OPEN custIDCursor;
	FETCH custIDCursor INTO custID;
	CLOSE custIDCursor;

END @