DELIMITER $$

DROP PROCEDURE IF EXISTS `test_SP` $$
CREATE PROCEDURE `test_SP`(
    IN para1 BIGINT,
    IN para2 nvarchar(1000),

    OUT para3 NVARCHAR(10),
    OUT para4 NVARCHAR(80),
    OUT para5 NVARCHAR(80),

    OUT para6 datetime,
    OUT para7 datetime,
    OUT para8 datetime,
    OUT para9 datetime

)
BEGIN

    SET para3 := 'PARAM 3';
    SET para4 := 'PARAM 4';
    SET para5 := 'PARAM 5';

    SET para6 := '2006-01-01 01:01:16';
    SET para7 := '2007-02-02 02:02:17';
    SET para8 := '2008-03-03 03:03:18';
    SET para9 := '2009-09-22 13:45:19';

END $$
DELIMITER ;
