CREATE OR REPLACE PROCEDURE get_permiso(DESCR IN PERMISO.DESCRIPCION%TYPE,
  cursor_ OUT SYS_REFCURSOR)
IS
BEGIN
OPEN cursor_ FOR
      SELECT ID
      FROM PERMISO WHERE DESCRIPCION = DESCR;
END;

VAR x REFCURSOR;
EXEC get_permiso('macro2', :x);
PRINT :x;

DataTable dt = new DataTable();
            dbManager.OpenConnection();
            List<OracleParameter> ls = new List<OracleParameter>
            {
                new OracleParameter
                {

                    OracleDbType = OracleDbType.NVarchar2,
                    Size=500,
                    ParameterName = "DESCR",
                    DbType = DbType.String,
                    Value = "Dashboard.DoSomething",
                    Direction = ParameterDirection.Input
                },
                new OracleParameter
                {

                    OracleDbType = OracleDbType.RefCursor,
                    ParameterName = "cursor_",
                    Direction = ParameterDirection.Output
                }
            };

            OracleCommand myCommand = (OracleCommand)dbManager.CreateCommand("get_permiso", ls);
            OracleDataAdapter adapt = new OracleDataAdapter(myCommand);
            adapt.SelectCommand.CommandType = CommandType.StoredProcedure;
            adapt.Fill(dt);