Используя PlSQL Требуется получить список пользователей, которые совершили подряд

CREATE TABLE temp_table(client varchar2(50), dt DATE, STATUS varchar2(3));
 
TABLE TEMP_TABLE created.
Elapsed: 00:00:00.071
/
INSERT INTO temp_table SELECT * FROM (
  SELECT 'Иванов' client, to_date('19.05.2014 12:20:05') dt, 'no' STATUS FROM dual
    UNION ALL
  SELECT 'Петров', to_date('19.05.2014 12:26:27') ,'no' FROM dual
    UNION ALL
  SELECT 'Иванов', to_date('19.05.2014 12:26:29') ,'no' FROM dual
    UNION ALL
  SELECT 'Сидоров', to_date('19.05.2014 12:29:47') ,'no' FROM dual
    UNION ALL
  SELECT 'Иванов', to_date('19.05.2014 12:33:31') ,'no' FROM dual
    UNION ALL
  SELECT 'Петров', to_date('19.05.2014 12:36:21') ,'yes' FROM dual
    UNION ALL
  SELECT 'Петров', to_date('19.05.2014 12:36:51') ,'no' FROM dual
    UNION ALL
  SELECT 'Сидоров', to_date('19.05.2014 12:36:57') ,'yes' FROM dual
    UNION ALL
  SELECT 'Петров', to_date('19.05.2014 12:46:24') ,'no' FROM dual
    UNION ALL
  SELECT 'Петров', to_date('19.05.2014 12:56:29') ,'no' FROM dual);
  
10 ROWS inserted.
Elapsed: 00:00:00.005
/
DECLARE
  ln$limit_fail_connection NUMBER := 3;
  lr$row_ temp_table%rowtype;
  cursor$get_user sys_refcursor;  
BEGIN  
  OPEN cursor$get_user FOR q'[select  
                              client, dt, status 
                            from
                            (
                              select t.*, 
                                row_number()over(partition by client order by dt desc) rn,
                                count(nullif(status,'yes'))over(partition by client order by dt desc rows between current row and 2 following) x
                              from temp_table t
                            )
                            where rn = 1 and x = :1]' USING ln$limit_fail_connection;
  loop  
    fetch cursor$get_user INTO lr$row_;
    exit WHEN cursor$get_user%notfound;
      
      dbms_output.put_line(rpad(lr$row_.client,20) || rpad(lr$row_.dt,40) || lr$row_.status);
    
  END loop;
  close cursor$get_user;
END;
 
 
anonymous block completed
Elapsed: 00:00:00.012
 
Иванов              19.05.2014 12:33:31                     no
Петров              19.05.2014 12:56:29                     no
/
DROP TABLE temp_table purge;
 
TABLE TEMP_TABLE dropped.
Elapsed: 00:00:00.724

(
                              SELECT t.*, 
                                ROW_NUMBER()OVER(partition BY client ORDER BY dt DESC) rn,
                                COUNT(NULLIF(STATUS,'yes'))OVER(partition BY client ORDER BY dt DESC ROWS BETWEEN CURRENT ROW AND 2 following) x
                              FROM temp_table t
                            )
                            WHERE rn = 1 AND x = :1]' USING ln$limit_fail_connection;

 DECLARE
CURSOR c_conect_cursor
IS 
SELECT
t1.client,t1.time_call,t1.status--,t2.client
FROM CON_1 t1, (SELECT client, COUNT(*)AS who
FROM CON_1
GROUP BY client) t2
WHERE t1.client=t2.client;
v_num NUMBER(3):=&ROWCOUNT;
v_time CON_1.time_call%TYPE;
v_client CON_1.client%TYPE;
v_limit NUMBER(3):=3;
v_status CON_1.status%TYPE;
v_conect_record c_conect_cursor%ROWTYPE;
BEGIN
OPEN  c_conect_cursor;
FETCH c_conect_cursor INTO v_client, v_time, v_status;
while c_conect_cursor%found AND v_status LIKE 'no'
 
Loop
INSERT INTO  CON_2(client, time_call, STATUS)
VALUES (v_client, v_time, v_status);
FETCH c_conect_cursor INTO v_client, v_time, v_status;
END Loop;
Close  c_conect_cursor;
END;