本文整理汇总了C#中System.Data.OracleClient.OracleCommand.ExecuteOracleNonQuery方法的典型用法代码示例。如果您正苦于以下问题:C# OracleCommand.ExecuteOracleNonQuery方法的具体用法?C# OracleCommand.ExecuteOracleNonQuery怎么用?C# OracleCommand.ExecuteOracleNonQuery使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.OracleClient.OracleCommand
的用法示例。
在下文中一共展示了OracleCommand.ExecuteOracleNonQuery方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: ExecuteOracleNonQuery
public int ExecuteOracleNonQuery(OracleCommand command, out OracleString rowid)
{
PrepareCommand(command);
try
{
int result = command.ExecuteOracleNonQuery(out rowid);
#if DEBUG
DatabaseLog.WriteInfo(command);
#endif
return result;
}
catch (Exception e)
{
DatabaseLog.WriteError(e.Message, command);
throw;
}
}
示例2: ExecuteNonQueryStoredProcedure
public int ExecuteNonQueryStoredProcedure(string strProcedureName, OracleParameter[] arlParams, OracleConnection connection, OracleTransaction objTransaction)
{
int intResult = 0;
using (OracleCommand command = new OracleCommand())
{
try
{
command.CommandType = CommandType.StoredProcedure;
command.CommandText = strProcedureName;
command.Transaction = objTransaction;
command.Connection = connection;
if (arlParams != null)
{
for (int i = 0; i < arlParams.Length; i++)
{
if (arlParams[i].Value == null)
{
arlParams[i].Value = DBNull.Value;
}
command.Parameters.Add(arlParams[i]);//.ToString().Trim('@'), OracleType.VarChar).Value = arlParams[i].Value;
}
}
OracleString rowID = "1";
intResult = command.ExecuteOracleNonQuery(out rowID);
command.Parameters.Clear();
return intResult;
}
catch (Exception ex)
{
throw (ex);
}
}
}