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