Page 1 of 1

Reg OraDirect, oracleExecuteNonQuery.,

Posted: Mon 14 Feb 2005 05:53
by Sreejith Rajan
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

Posted: Wed 16 Feb 2005 11:56
by Paul
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.