SOS![存储过程]出现了:第 1 行: '@P2' 附近有语法错误

[bluetooths]

存储过程为:
create procedure sp_CommInfo_Add
@Title nvarchar( 255 ),
@DevelopDateTime nvarchar( 50 )
as
Insert into CommInfo (Title,DevelopDateTime)
values (@Title, @DevelopDateTime )


其中的代码为:
CallableStatement cstmt = conn.prepareCall( "{ call sp_CommInfo_Add( ? ? ) }" );
cstmt.setString(1," Title");
cstmt.setString(2, "mydate");
cstmt.execute();
两个全部是输入参数!
执行时报错!
description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]第 1 行: '@P2' 附近有语法错误。
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)

......
我改为一个参数是,程序通过如:
create procedure sp_CommInfo_Add
@Title nvarchar( 255 )
as
Insert into CommInfo (Title)
values (@Title)


其中的代码为:
CallableStatement cstmt = conn.prepareCall( "{ call sp_CommInfo_Add( ? ? ) }" );
cstmt.setString(1," Title");
cstmt.execute();
在线!!!!!!!!!!!!!!!

[cjxiaoh]

DevelopDateTime 这个字段是nvarchar型的吗？好像应该是日期或者时间型的吧，看看你数据库定义的是什么类型？