16.2.12.1616 These clauses are not valid as of Oracle 10g

The code below shows this error (Oracle 19c):

Is this reported by Oracle or by TOAD?

CREATE PROCEDURE proc AS
  v_some_ot some_ot := NEW some_ot();
BEGIN
  FOR cur_prb IN
  (
      SELECT VALUE( ov ) AS val
        FROM object_view ov
       ORDER BY ov.some_column
  )
  LOOP
    NULL;
  END LOOP;
END proc;

This even breaks the outline (proc2 is missing):

image

Hi Peter,

It is reported by Toad.
I removed it because it's not quite clear when or where that message is valid.

I resolved another issue which may be reponsible for the broken navigator output.

Should be in Toad soon (QP5.dll version 5.390).

Thanks,
Andre

1 Like