How to get data in oracle refcursor in ADO.NET with parameterized query

string sql = "seect userName,Location,number where USER_ID=:id";

    OracleCommand cmd = new OracleCommand(sql, conn);
    cmd.BindByName = true;
    OracleParameter oparam = cmd.Parameters.Add("refcursor",OracleType.RefCursor);
    oparam.Direction = ParameterDirection.OutPut;
    cmd.Parameters.Add("id", userId);
    cmd.Connection.Open();
    cmd.ExecuteNonQuery();
    OracleDataAdapter adapter = new OracleDataAdapter(cmd);
    DataSet ds = new DataSet();
    adapter.Fill(ds);
return ds;

string sql = "seect userName,Location,number where USER_ID=:id";

    OracleCommand cmd = new OracleCommand(sql, conn);
    cmd.BindByName = true;
    OracleParameter oparam = cmd.Parameters.Add("refcursor",OracleType.RefCursor);
    oparam.Direction = ParameterDirection.OutPut;
    cmd.Parameters.Add("id", userId);
    cmd.Connection.Open();
    cmd.ExecuteNonQuery();
    OracleDataAdapter adapter = new OracleDataAdapter(cmd);
    DataSet ds = new DataSet();
    adapter.Fill(ds);
return ds;