none
how to save date in oracle table using stored procedure in C#.net RRS feed

  • Question

  • hi friends ,
    i have table in oracle 10g.in 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'))");
                
                adp.Fill(ds)

     

    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

Answers