Hi all,

I am having an issue with uploading a dataset to an oracle table. It appears to be associated with the date field that i am attempting to pass in. If i attempt to pass in with a valid formatted DateTime (mm/dd/yyyy) it send an oracle error "Not a Valid Month". If i update this to show as either MON or MONTH format and pass in that value, i receive oracle error "a non-numeric character was found where a numeric was expected".

Please help! I have pasted some of the code below:
--------------------------------------------------
ASP.NET code

Database dbOracle = new Database();
OracleCommand cmdOra = new OracleCommand(StoredProceduresNames.InsertData, dbOracle.OConnection);
cmdOra.CommandType = CommandType.StoredProcedure;
OracleDataAdapter da = new OracleDataAdapter();

//Add the sales date field
cmdOra.Parameters.Add(DetailParameters.SalesDate, OracleDbType.Date, 12, Column.SALES_MM_YY);

da.InsertCommand = cmdOra;
da.Update(dsDataSet, dtDataTable);
---------------------------------------------------
Oracle Sproc code

PROCEDURE INSERT_VALUES
(
v_SALES_DATE IN DATE
)
IS
BEGIN

INSERT INTO TABLE
(
SALE_DT
)
VALUES
(
v_SALES_DATE
);
END;

I was able to fix this issue by converting my DateTime to a dd MMM yyyy string format and passing that value in. Oracle can then convert this string into the correct DateTime in the database.