Create Procedure with Insert

[Michael Brown]

Alright I have this procedure that I am creating and it's giving me problems. I can't seem to find the problem as it look sas if I am doing everything correctly. Please help.

ERROR: Missing EndOfFile at 'DECLARE'

DELIMITER $$

CREATE PROCEDURE NewListing
(
IN pCatID int,
IN pTitle varchar(50),
IN pDescription text,
IN pListingLength int
)

BEGIN

DECLARE vStart datetime;
DECLARE vEnd datetime;

SET vStart = UTC_TIMESTAMP();
SET vEnd = DATE_ADD(vStart, INTERVAL pListingLength DAY);

INSERT INTO Listings
(
CatID,
Title,
Description,
StartDateTime,
EndDateTime
)
VALUES
(
pCatID,
pTitle,
pDescription,
vStart,
vEnd
);

END $$
DELIMITER;