My Oracle Support Banner

Use _allow_level_without_connect_by to Revert Back to 9i Hierarchical Query Behavior (Doc ID 271939.1)

Last updated on NOVEMBER 22, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
Information in this document applies to any platform.
CONNECT BY / START

Symptoms

Using a query like the following works fine in 9i, but will generate errors in 10g.

NOTE: This query comes from sample code found at http://otn.oracle.com/oramag/webcolumns/2003/techarticles/gennick_connectby.html

SELECT level, assembly_id, assembly_name, parent_assembly
FROM bill_of_materials
UNION
SELECT level, assembly_id, assembly_name, parent_assembly
FROM bill_of_materials
START WITH parent_assembly IS NULL
CONNECT BY parent_assembly = PRIOR assembly_id;

fails on 10g with

ORA-01788: CONNECT BY clause required in this query block

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.