vb.net - Dotnet Dataadapter Error not a valid month ORA-01843

Question

I am updating data from dataset to oracle (19c client) using my dotnet application.

    ds.Locale = System.Globalization.CultureInfo.InvariantCulture
    SALESSTOPAdapter.UpdateCommand = New OracleCommand("PKG_SalesStop.UpdateSALESSTOP", oConn)
    SALESSTOPAdapter.UpdateCommand.CommandType = CommandType.StoredProcedure
    SALESSTOPAdapter.UpdateCommand.UpdatedRowSource = UpdateRowSource.None
        param = SALESSTOPAdapter.InsertCommand.Parameters.Add("pREG_DATE", OracleDbType.Date, 7, "REG_DATE")
   param.Direction = ParameterDirection.Input
   param.SourceVersion = DataRowVersion.Current
   SALESSTOPAdapter.UpdateCommand.BindByName = True
   rowsUpdated += SALESSTOPAdapter.Update(ds, "SALESSTOP")

So from "SALESSTOPAdapter.Update(ds, "SALESSTOP")" i am getting error as "ORA-01843: not a valid month"

Is there any way to remove this error by setting nay property in parameter setting. Any suggessions are most welcome.

Thank you in advance Sangeetha

question from:https://stackoverflow.com/questions/65935616/dotnet-dataadapter-error-not-a-valid-month-ora-01843

Answer 1

Waitting for answers