Wednesday, March 7, 2012

Error Using ODP.NET


Hi ,
I am trying to connect to ORacle using ODP.NET. I am getting an "Object
must implement IConvertible" error.
I researched this issue online and it seems it maybe mis matched data
types in the parameters collection, however i have varchar2 in the
oracle proc and OracleType.Varchar in my code.(I am trying to use the
OracleHelper class, this logic worked with OleDB).
OracleParameter[] parameters =
{
new OracleParameter("p_Number", OracleType.VarChar),
new OracleParameter("p_Name",OracleType.VarChar),};
parameters[0].Value = "111";
parameters[1].Value = "guest";
OracleHelper. ExecuteNonQuery(connectionstring,procNam
e, parameters);
Please help !
- Arthur
*** Sent via Developersdex http://www.examnotes.net ***Never mind, I used another overload and made it work
(for anyone interested)
OracleHelper.ExecuteNonQuery(con, CommandType.StoredProcedure, procName,
parameters);
Arthur
*** Sent via Developersdex http://www.examnotes.net ***

No comments:

Post a Comment