Error Using ODP.NET  
Author Message
RobertoPasqualini





PostPosted: Mon Jun 19 13:52:16 CDT 2006 Top

SQL Server Developer >> 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,procName, parameters);

Please help !
- Arthur

*** Sent via Developersdex http://www.hide-link.com/ ***

SQL Server294  
 
 
Ben





PostPosted: Mon Jun 19 13:52:16 CDT 2006 Top

SQL Server Developer >> Error Using ODP.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.developersdex.com ***