Custom Search . . .

Saturday, November 24, 2007


Oracle Server - Enterprise Edition - Version:
This problem can occur on any platform.
After upgrading to Oracle 10g, started getting an ORA-1788 error for a query that includes the LEVEL pseudo column. This query was running fine on 9i.


On 9i:

SQL> select level from dual;


On 10g:

SQL> select level from dual;
select level from dual
ERROR at line 1:
ORA-01788: CONNECT BY clause required in this query block


SQL> alter system set "_allow_level_without_connect_by"=true scope=spfile;

or if using a pfile add the line


at the beginning of the pfile.

Both cases will require a restart of the database to take effect.

1 comment:

Anonymous said...

Thanks, exactly what I needed