karanba
asked on
How to convert OracleDbType.Date to .net DateTime
Hi,
I want to convert OracleDbType.Date to .net DateTime.
OracleParameter param1 = new OracleParameter("dateP", OracleDbType.Date);
param1.Direction = System.Data.ParameterDirec tion.Outpu t;
cmd.Parameters.Add(param1) ;
cmd.ExecuteNonQuery();
---> ? DateTime d = cmd.Parameters["dateP"].Va lue
And a second question does the given parameter name in OracleParameter must be the same with defined in procedure?
I want to convert OracleDbType.Date to .net DateTime.
OracleParameter param1 = new OracleParameter("dateP", OracleDbType.Date);
param1.Direction = System.Data.ParameterDirec
cmd.Parameters.Add(param1)
cmd.ExecuteNonQuery();
---> ? DateTime d = cmd.Parameters["dateP"].Va
And a second question does the given parameter name in OracleParameter must be the same with defined in procedure?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
that gives the following error.
Unable to cast object of type 'Oracle.DataAccess.Types.O