Unexpected Hint: "Value assigned to..."

[Philippe Malera]

If you compile this procedure in a program window, you will get this unexpected hint :

Error: Hint: Value assigned to 'r_row' never used in 'unexpected_hint#p'

But in fact it is used !

CREATE OR REPLACE PROCEDURE unexpected_hint#p AS

  r_row DUAL%ROWTYPE;

  ------------------------------------------
  FUNCTION get_row RETURN DUAL%ROWTYPE IS
    l_result DUAL%ROWTYPE;
  BEGIN
    SELECT * INTO l_result FROM DUAL;
    RETURN l_result;
  END get_row;

  ------------------------------------------
  PROCEDURE test AS
  BEGIN
    IF r_row.dummy = 'X'
    THEN
      dbms_output.put_line('Bingo');
    END IF;
  END test;

BEGIN
  r_row := get_row;
  test;
END;

 

[Marco Kalter]

This does indeed not seem right. We'll fix it.