DECLARE
  V1 CLOB;
  V2 VARCHAR2(50);
  CURSOR C2 IS
    SELECT SAMPLE
      FROM ALL_F
     WHERE SAMPLE IN ('AB35652626-G8');
  CURSOR C1(P_SAMPLE_ID VARCHAR2) IS
    SELECT 
     P.GENOTYPE
      from T1 P
     WHERE P.SAMPLE_ID = P_SAMPLE_ID;
BEGIN
  FOR L1 IN C2 LOOP
     OPEN C1(L1.SAMPLE);
    LOOP
      FETCH C1
        INTO V2;
      EXIT WHEN C1%NOTFOUND;
      V1 := V1 || V2;
    END LOOP;
    INSERT INTO X VALUES (NULL, V1);
    
    CLOSE C1;
  END LOOP;  
END;