ORA-30002: SYS_CONNECT_BY_PATH function is not allowed here



ORA-30002: SYS_CONNECT_BY_PATH function is not allowed here..

Answer / guest

Cause: SYS_CONNECT_BY_PATH function is called at places
other than select list.

Action: Remove calls to SYS_CONNECT_BY_PATH function at
places other than select list.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Oracle Errors Interview Questions

ORA-36996: (XSRELGID13) Valueset workspace object should be defined over dimension workspace object.

1 Answers  


ORA-01168: physical block size string does not match size string of other members

1 Answers  


ORA-09835: addCallback: callback port is already in a set.

1 Answers  


ORA-00828: specified value of shared_pool_reserved_size inconsistent with internal settings

1 Answers  


ORA-23366: integer value string is less than 1

1 Answers  






ORA-09832: infoCallback: bad message format.

1 Answers  


ORA-16008: indeterminate control file checkpoint

1 Answers  


NNL-00994: Responses received: number

1 Answers  


ORA-02756: osnfsmnam: name translation failure

1 Answers  


TNS-00137: Failed to get TNS error message file entry

1 Answers  


DRG-10101: no value for argument: string

1 Answers  


TNS-12511: TNS:service handler found but it is not accepting connections

1 Answers  


Categories