how to save date in oracle table using stored procedure in RRS feed

  • Question

  • hi friends ,
    i have table in oracle which there are a column with date datatype.
    I insert value in that table using stored procedure.i am using following code..


     OleDbDataAdapter adp = new OleDbDataAdapter("ins_emp",con);
                DataSet ds = new DataSet();
                adp.SelectCommand.CommandType = CommandType.StoredProcedure;
     adp.SelectCommand.Parameters.AddWithValue("@psdate", "(to_date('"+Label1.Text+ "','mm/dd/yyyy'))");


    but i get the follwing error..
    ORA-01858: a non-numeric character was found where a numeric was expected
    or how save date from .net in oracle.
    Help me on this topic.Its urgent...
    Thanks in advance.
    Randeep Chauhan


    Randeep Chuahan
    Saturday, November 5, 2011 5:51 AM