public static object ExecuteScalar(string connectionString, string spName, params object[] parameterValues)
{
if (parameterValues != null && parameterValues.Length > 0)
{
OracleParameter[] commandParameters = OracleDataAccessParameterCache.GetSpParameterSet(connectionString, spName);
OracleDataAccess.AssignParameterValues(commandParameters, parameterValues);
return(OracleDataAccess.ExecuteScalar(connectionString, CommandType.StoredProcedure, spName, commandParameters));
}
return(OracleDataAccess.ExecuteScalar(connectionString, CommandType.StoredProcedure, spName));
}
public static XmlReader ExecuteXmlReader(OracleTransaction transaction, string spName, params object[] parameterValues)
{
if (parameterValues != null && parameterValues.Length > 0)
{
OracleParameter[] commandParameters = OracleDataAccessParameterCache.GetSpParameterSet(transaction.Connection.ConnectionString, spName);
OracleDataAccess.AssignParameterValues(commandParameters, parameterValues);
return(OracleDataAccess.ExecuteXmlReader(transaction, CommandType.StoredProcedure, spName, commandParameters));
}
return(OracleDataAccess.ExecuteXmlReader(transaction, CommandType.StoredProcedure, spName));
}
public static OracleParameter[] GetSpParameterSet(string connectionString, string spName)
{
return(OracleDataAccessParameterCache.GetSpParameterSet(connectionString, spName, false));
}
