Cursor in temporary table.

[Marciel]

I lost about 10 minutes trying to understand what the author was thinking about writing this code. NO_DATA_FOUND.

Select all

DECLARE 
  CURSOR CUR IS 
    SELECT COD, 
           DESCR 
      FROM TMP_TABLE; 
BEGIN 
  DELETE FROM TMP_TABLE; 
 
  INSERT INTO TMP_TABLE 
    (SELECT COD, 
            DESCR 
       FROM TABELA); 
 
  FOR REC IN CUR LOOP 
    ... 
  END LOOP; 
END; 

[dr_gori]

Heheh, because it is, he could have done straight into the table ...: - /

[Marciel]

Such cases usually happen with reused codes (Ctrl + C Ctrl + V). The famous "The code is ready, just adapt."