Oracle® Database 8i | 9i | 10g | 11g | 12c | 18c | 19c Error Codes

Information for Database Error Code ORA-30398: illegal JOIN KEY clause
Oracle® Database Error ORA-30398583/19

ORA-30398: illegal JOIN KEY clause

Cause: A JOIN KEY clause was specified that did not conform to certain requirements. A JOIN KEY clause connecting a child level with its non-immediate ancestor level is allowed only when that child level and its ancestor level satisfy the following conditions:1. The immediate parent of the child level must be a skip level.2. The child level cannot be a skip level.3. The ancestor level must be a non-skip level.4. The ancestor level must be the nearest non-skip level to the child level in the hierarchy.

Action: Modify the JOIN KEY clause so that it satisfies the conditions mentioned above.

Error Type: ORA

Oracle® Database Error Codes 8i | 9i | 10g | 11g | 12c | 18c | 19c

Record: 1/1

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners

Oracle: Registered trademark of Oracle