when I issued a select in 10.2 with a query defined in the WITH-clause but not referenced later on, I received an ORA-32035 exception:
10.2 > with a as (select 1 a from dual)
2 select * from dual;
with a as (select 1 a from dual)
*
ERROR at line 1:
ORA-32035: unreferenced query name defined in WITH clause
I was a bit surprised today, when I saw the following running against 11.2:
11.2 > with a as (select 1 a from dual)
2 select * from dual;
D
-
X
I don’t manage to get a ORA-32035 on 11.2 ….
It’s documented though on
ORA-32035
that I should get one.
So, is it a bug or a feature ?
