Is "Level" a Reserved Word in 10G?

[Speed]

The following query has worked fine up until Oracle 10g.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
select level, classn_id, classn_classn_id, classn_type, code, description
from mas.classifications
where classn_classn_id is null
union
select 0,0,0,'0','0','General Explanatory Notes' from dual
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

When the query is executed in 10g I get the following error:

"ORA-01788: CONNECT BY clause required in this query block". Apparently this message is misleading because a developer in another forum got the exact same error message, and he also had a field called level. When he renamed this to "tree_level" the query executed without any problems.

Does anyone know if level is a reserved word in 10g?

Thanks.

Regards,

Steve

 

[Joachim Rupik]

Hello,

Level was always a reserved word in Oracle. It is also an ANSI reserved word.

 

[Speed]

Thanks Joachim, I wonder why it's worked before then. This system has been running for years before I took over maintenance of it and it has worked fine with all previous versions of Oracle.

Regards,

Steve