存储过程返回值为int型,有一个参数,请问asp.net调用informix存储过程和sql存储过程有什么不同之处?
存储过程调用code:
using (OdbcConnection odbcon = new OdbcConnection(conStringCX))
{
using (OdbcCommand odbcmd = new OdbcCommand("sp_investrecord", odbcon))
{
odbcmd.CommandType = CommandType.StoredProcedure;
OdbcParameter parm = new OdbcParameter("strdescription", cust_cityname);
odbcmd.Parameters.Add(parm);
odbcon.Open();
int i = odbcmd.ExecuteNonQuery();
return i;
}
}
error:ERROR [42000] [Informix][Informix ODBC Driver][Informix]A syntax error has occurred.