Reg OraDirect, oracleExecuteNonQuery.,

Sreejith Rajan · Post by **Sreejith Rajan** » Mon 14 Feb 2005 05:53

Am using oradirect to connect to oracle9i and VB.NEt.., but probs with
ExecuteOracleNonQuery()..,asking for parameter..,

cmd.ExecuteOracleNonQuery() // not working asking for argument not specified for row id.., and how to convert integer value to oracle string//

Plz send me the code for that..,

Probs with timestamp also.., because..,Vb.Net shows error that it doenot
support Timestamp for oracle9i..,

Need HELP .., VERY URGENT FOR PROJECT

Paul · Post by **Paul** » Wed 16 Feb 2005 11:56

You can use the following code for defining parameters

OracleParameter p1 = command.Parameters.Add("param1", OracleDbType. ...);
p1.Value = ...;

Please see OraDirect .NET documentation how to work with
OracleParameterCollection.

Timestamp is needed in Oracle client 9, Oracle Server 9 or greater. Please
check version of your Oracle client.