cmd.Parameters.Clear() cmd.CommandText = "UPDATE TBL_xxx_xxx SET NEXT=null, ACTIONDATE=SYSDATE, comments=:pcomments, STATUS=11 WHERE ACTIONDATE IS NULL AND WFID=:pwid AND ACTIONBY=:pactionby" cmd.CommandType = CommandType.Text cmd.BindByName = True cmd.Parameters.Add(New OracleParameter(":pcomments", OracleDbType.Varchar2)).Value = somevalue cmd.Parameters.Add(New OracleParameter(":pwid", OracleDbType.Int64)).Value = somevalue cmd.Parameters.Add(New OracleParameter(":pactionby", OracleDbType.Varchar2)).Value = somevalue cmd.ExecuteQuery()
Quote: 6.2.4.5 BindByName This property specifies the binding method in the collection. Declaration C# // C# public bool BindByName {get; set;} Property Value Returns true if the parameters are bound by name; returns false if the parameters are bound by position. Remarks Default = false.
// C# public bool BindByName {get; set;}
true
false
Default = false.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)