I wnat to pass the date as a paremeter to the oracle.Code:CREATE FUNCTION get_bal(Daate1 in date,dev in number ) RETURN NUMBER IS acc_bal NUMBER(11,2); BEGIN SELECT VOUCHER_NO INTO acc_bal FROM TBL_PAYMENT_TRN WHERE FROM_DATE < Daate1 AND DEVELOPMENT_AREA_ID = dev; RETURN(acc_bal); END; /
Code:OracleCommand objCmd = new OracleCommand("get_bal", con); objCmd.CommandType = CommandType.StoredProcedure; objCmd.Parameters.Add("Daate1", OracleDbType.Date).Value = DateTime.Parse(ds.Tables[0].Rows[0]["FROM_DATE"].ToString()).Date ; objCmd.Parameters.Add("dev", OracleDbType.Int64).Value = Session["DEV_AREA_ID"]; objCmd.Parameters.Add("return_value", OracleDbType.Int64).Direction = ParameterDirection.ReturnValue; con.Open(); objCmd.ExecuteNonQuery(); s = objCmd.Parameters["return_value"].Value.ToString();Everytime the error comes not a valid month,u can see abve in Month -10 is coming,then y it is not valid?Code:DateTime.Parse(ds.Tables[0].Rows[0]["FROM_DATE"].ToString()).Date ; {10/31/2010 12:00:00 AM} Date: {10/31/2010 12:00:00 AM} Day: 31 DayOfWeek: Sunday DayOfYear: 304 Hour: 0 Kind: Unspecified Millisecond: 0 Minute: 0 Month: 10 Second: 0 Ticks: 634240800000000000 TimeOfDay: {00:00:00} Year: 2010




Reply With Quote