>> Calling an SP that inserts doesn't work??

HI,

I have written a stored proc that inserts into a mssql db, however when i try and call it I get an error. In query analyser i get

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '997'.

Does anyone know what im doing wrong?

sp:

ALTER Procedure dbo.Admin_InsertWebPage
(
@AgentID int,
@WPtitle nvarchar(150),
@WPBody text,
@WPMetaDesc varchar(255),
@WPMetaKeywords varchar(255),
@WPCreation smalldatetime,
@WPLastedited smalldatetime,
@WPsubject varchar(150),
@WPmodule int
)
As

/* THIS INSERTS NEW WebPages into the db*/

INSERT INTO tblWebPages
(
AgentId,Wptitle,WpBody,WPMetaDesc,WPMetaKeywords,WPCreation,WPLastedited,WPsubject,WPmodule
)

VALUES
(
@AgentID,@WPtitle,@WPBody,@WPMetaDesc,@WPMetaKeywords,@WPCreation,@WPLastedited,@WPsubject,@WPmodule
)


Calling code:

Admin_InsertWebPage (997,'test','test','test','test',getdate(),getdate(),'test',2)

Best regards

Technicweb

thanks but,

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near ')'.

I get this now, im guessing its somethign to do with the getdate() functions.