Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kranthi_victroy
Starting Member
5 Posts |
 Posted - 2007-08-27 : 17:09:58
|
| Hi, the stored procedure returns only the first letter of the ouput parameter i.e 'e'. spvr_ErrorDescription='error while updating data'. Actually It must return 'error while updating data'. can anybody helpme to solve this issue.public string UserCostCenter_Upd(string spvp_Offering, string spvp_UserId, string spvp_CostCenter, DateTime spvp_StartDate, DateTime spvp_ExpiryDate, ref string spvr_ErrorDescription) { // The instance ds will hold the result set obtained from the DataRequest DataSet ds = new DataSet(); RequestParameter[] parms = new RequestParameter[7]; parms[0] = new RequestParameter("@Return_Value", DbType.Int32, ParameterDirection.ReturnValue, null, true); parms[1] = new RequestParameter("@p_Offering", DbType.AnsiString); parms[1].Value = spvp_Offering; parms[2] = new RequestParameter("@p_UserId", DbType.AnsiStringFixedLength); if (spvp_UserId == null) parms[2].Value = DBNull.Value; else parms[2].Value = spvp_UserId; parms[3] = new RequestParameter("@p_CostCenter", DbType.AnsiString); if (spvp_CostCenter == null) parms[3].Value = DBNull.Value; else parms[3].Value = spvp_CostCenter; parms[4] = new RequestParameter("@p_StartDate", DbType.DateTime); if (spvp_StartDate == null) parms[4].Value = DBNull.Value; else parms[4].Value = spvp_StartDate; parms[5] = new RequestParameter("@p_ExpiryDate", DbType.DateTime); if (spvp_ExpiryDate == null) parms[5].Value = DBNull.Value; else parms[5].Value = spvp_ExpiryDate; parms[6] = new RequestParameter("@r_ErrorDescription", DbType.String, ParameterDirection.InputOutput , null, true); parms[6].Value = spvr_ErrorDescription; // Create an instance of DataSQLClient AirProducts.GlobalIT.Framework.DataAccess.DataSqlClient daSQL = new DataSqlClient(Constants.ApplicationName); ; // typDSRef holds the ref. to the strongly typed dataset DataSet typDSRef = (DataSet)ds; DataSet resultDataSet = daSQL.ExecuteDataSet("[ap_UserCostCenter_Upd]", ref parms); // Call DataHelper.MapResultSet function for mapping the result set obtained in ordinary DataSet to strongly typed DataSet DataHelper helper = new DataHelper(); if (!helper.MapResultSet(ref typDSRef, resultDataSet)) ds = null; // Returns a null reference if the DataHelper.MapResultSet is failed. //returnCode = (int)parms[0].Value; spvr_ErrorDescription = (string)((parms[6].Value == DBNull.Value) ? null : parms[6].Value); return spvr_ErrorDescription ; } |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-08-27 : 17:12:11
|
| Did you set the size of the parameter properly?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-08-27 : 17:15:41
|
You should not set theparms[0] = new RequestParameter("@Return_Value", DbType.Int32, ParameterDirection.ReturnValue, null, true);@Return_value is automatically set when creating dataset. at least in VB.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
|
|
regarding output parameters in stored procedure