public DataTable ExecuteDataTableProc(string storedProcedureName, params object[] parameterValues)
{
OracleParameter[] commandParameters = OracleHelperParameterCache.GetSpParameterSet(connectionString, storedProcedureName);
AssignParameterValues(commandParameters, parameterValues);
DataTable dt = OracleHelper.ReadTable(connectionString, CommandType.StoredProcedure, storedProcedureName, commandParameters);
return(dt);
}
public DataTable ExecuteDataTableProc(string storedProcedureName, Dictionary <string, object> commandParameters)
{
Dictionary <string, string> tmpIpMappingOp;
//OracleParameter[] sqlParams = Dp2Op(this.GetOwner(), storedProcedureName, commandParameters, out tmpIpMappingOp);
OracleParameter[] sqlParams = OracleHelperParameterCache.GetSpParameterSet(connectionString, storedProcedureName);
AssignParameterValues(sqlParams, commandParameters, out tmpIpMappingOp);
DataTable dt = OracleHelper.ReadTable(connectionString, CommandType.StoredProcedure, storedProcedureName, sqlParams);
SetOutParamValue(commandParameters, tmpIpMappingOp, sqlParams);
return(dt);
}
public DataTable ExecuteDataTable(string cmdText, Dictionary <string, object> commandParameters)
{
OracleParameter[] sqlParams = Dp2Op(commandParameters);
return(OracleHelper.ReadTable(connectionString, CommandType.Text, cmdText, sqlParams));
}