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

TNS-01168: Cannot allocate memory

1 Answers  


ORA-33086: (XSAGINIT01) AGGMAP workspace object cannot be dimensioned by a conjoint dimension.

1 Answers  


ORA-02209: invalid MAXTRANS option value

1 Answers  


NPL-00300: maximum ASN.1 element nesting depth string exceeded on read

1 Answers  


EXP-00102: Resumable parameters ignored -- current session not resumable

1 Answers  






ORA-36970: (XSRELTBL12) workspace object must be a self-relation.

1 Answers  


ORA-15002: parameter LOCK_NAME_SPACE exceeds limit of string characters

1 Answers  


ORA-25297: The message options only make sense for buffered messages

1 Answers  


ORA-23607: invalid column "string"

1 Answers  


ORA-30553: The function is not deterministic

1 Answers  


ORA-01944: IDENTIFIED EXTERNALLY already specified

1 Answers  


TNS-00528: Protocol Adapter not loaded

1 Answers  


Categories