public Permisos TraerPermisosPorRolConEntidad(int _rol) { OracleCommand cmd = null; OracleDataReader dr = null; DataSet datos = new DataSet(); DataTable dt = new DataTable(); Permisos permisos = new Permisos(); try { string procedure = "PERMISOS_TRAER_PERMISOS_ROL"; OracleConnection cnx = Global.CadenaConexionGlobal; cmd = new OracleCommand(procedure, cnx); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("V_ID_ROL", OracleDbType.Int32).Value = _rol; OracleParameter retorno = cmd.Parameters.Add("C_PERMISOS", OracleDbType.RefCursor); retorno.Direction = ParameterDirection.Output; cmd.Connection.Open(); dr = cmd.ExecuteReader(); if (dr.HasRows) { dt.Load(dr); datos.Tables.Add(dt); permisos.FillFromDataSet(datos); } } catch (Exception pe) { Console.Write(pe.Message); } finally { cmd.Connection.Close(); } return(permisos); }