Adding oracle parameters

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

HI

I'm trying to add parameters based on the columns in my dataset (Oracle)
using this command, but I get this message

thecmd.Parameters.Add(colname,
oracleds.Tables(0).Columns(colloopy).DataType,
oracleds.Tables(0).Columns(colloopy).MaxLength) 'ERIC


**VALUE OF TYPE system.type cannot be converted to
system.data.oracleclient.oracletype **

thecmd is defined as oraclecommand, oraclds is oracledataset, but they don't
seem to be compatable?

Thanks
 
The DataType property of the column return a .NET type. You need to set an
oracle data type. I don't know the name of the enumeration (don't use
oracle), but there is one. When the intellisense comes up for the Add
method, it will say what the type of that parameter should be.
 
Back
Top