DROP PROCEDURE IF EXISTS `CALCRECORD`; delimiter ;; CREATE PROCEDURE `CALCRECORD`(IN `PID` INT, IN `PEVENT` VARCHAR ( 255 ), IN `PCPID` INT, IN `PNOW` DATETIME) BEGIN INSERT INTO AR_BS_BONUS_103_CALC_EVENT ( ID, EVENT, CREATION_TIME, CALC_PERIOD_ID ) VALUES ( PID, PEVENT, NOW(), PCPID ); END ;;