/// <summary> /// The execute reader. /// </summary> /// <param name="transaction"> /// The transaction. /// </param> /// <param name="spName"> /// The sp name. /// </param> /// <param name="parameterValues"> /// The parameter values. /// </param> /// <returns> /// The <see cref="OracleDataReader"/>. /// </returns> public static OracleDataReader ExecuteReader( OracleTransaction transaction, string spName, params object[] parameterValues) { // if we got parameter values, we need to figure out where they go if ((parameterValues != null) && (parameterValues.Length > 0)) { OracleParameter[] commandParameters = OracleHelperParameterCache.GetSpParameterSet(transaction.Connection.ConnectionString, spName); AssignParameterValues(commandParameters, parameterValues); return(ExecuteReader(transaction, CommandType.StoredProcedure, spName, commandParameters)); } // otherwise we can just call the SP without params return(ExecuteReader(transaction, CommandType.StoredProcedure, spName)); }
/// <summary> /// The execute non query. /// </summary> /// <param name="transaction"> /// The transaction. /// </param> /// <param name="spName"> /// The sp name. /// </param> /// <param name="parameterValues"> /// The parameter values. /// </param> /// <returns> /// The <see cref="int"/>. /// </returns> public static int ExecuteNonQuery(OracleTransaction transaction, string spName, params object[] parameterValues) { // if we got parameter values, we need to figure out where they go if ((parameterValues != null) && (parameterValues.Length > 0)) { // pull the parameters for this stored procedure from the parameter cache (or discover them & populet the cache) OracleParameter[] commandParameters = OracleHelperParameterCache.GetSpParameterSet(transaction.Connection.ConnectionString, spName); // assign the provided values to these parameters based on parameter order AssignParameterValues(commandParameters, parameterValues); // call the overload that takes an array of OracleParameters return(ExecuteNonQuery(transaction, CommandType.StoredProcedure, spName, commandParameters)); } // otherwise we can just call the SP without params return(ExecuteNonQuery(transaction, CommandType.StoredProcedure, spName)); }