public static OracleDataReader ExecuteReader(OracleTransaction transaction, string spName, params object[] parameterValues)
{
//if we receive parameter values, we need to figure out where they go
if ((parameterValues != null) && (parameterValues.Length > 0))
{
OracleParameter[] commandParameters = OracleDataAccessParameterCache.GetSpParameterSet(transaction.Connection.ConnectionString, spName);
AssignParameterValues(commandParameters, parameterValues);
return(ExecuteReader(transaction, CommandType.StoredProcedure, spName, commandParameters));
}
//otherwise we can just call the SP without params
else
{
return(ExecuteReader(transaction, CommandType.StoredProcedure, spName));
}
}
public static XmlReader ExecuteXmlReader(OracleTransaction transaction, string spName, params object[] parameterValues)
{
//if we receive 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 & populate the cache)
OracleParameter[] commandParameters = OracleDataAccessParameterCache.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(ExecuteXmlReader(transaction, CommandType.StoredProcedure, spName, commandParameters));
}
//otherwise we can just call the SP without params
else
{
return(ExecuteXmlReader(transaction, CommandType.StoredProcedure, spName));
}
}