Reg OraDirect, oracleExecuteNonQuery.,

Reg OraDirect, oracleExecuteNonQuery.,

Postby 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
Sreejith Rajan
 
Posts: 1
Joined: Mon 14 Feb 2005 05:14
Location: Bangalore

Postby 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.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to dotConnect for Oracle