public object ExecuteScalarProc(string owner, string storedProcedureName, Dictionary <string, object> commandParameters)
{
Dictionary <string, string> tmpIpMappingOp;
//OracleParameter[] sqlParams = Dp2Op(owner, storedProcedureName, commandParameters, out tmpIpMappingOp);
OracleParameter[] sqlParams = OracleHelperParameterCache.GetSpParameterSet(connectionString, storedProcedureName);
AssignParameterValues(sqlParams, commandParameters, out tmpIpMappingOp);
if (sqlParams != null)
{
object result = OracleHelper.ExecuteScalar(connectionString, CommandType.StoredProcedure, storedProcedureName, sqlParams);
SetOutParamValue(commandParameters, tmpIpMappingOp, sqlParams);
return(result);
}
else
{
return(null);
}
}
public object ExecuteScalar(string cmdText, Dictionary <string, object> commandParameters)
{
OracleParameter[] sqlParams = Dp2Op(commandParameters);
return(OracleHelper.ExecuteScalar(connectionString, CommandType.Text, cmdText, sqlParams));
}
