Adding oracle parameters

[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

 

[Marina]

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.

 

[Sahil Malik [MVP]]

OracleDbType?

- Sahil Malik [MVP]
Upcoming ADO.NET 2.0 book - http://tinyurl.com/9bync