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