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-22065: number to text translation for the given format causes overflow

1 Answers  


DRG-11427: valid gist level values are string

1 Answers  


ORA-31013: Invalid XPATH expression

1 Answers  


ORA-16806: Supplemental logging is not turned on.

1 Answers  


ORA-31698: Error stack buffer size must be specified and must be greater than 0.

1 Answers  






ORA-07393: unable to delete text file

1 Answers  


ORA-19676: one or more files failed during proxy backup or restore

1 Answers  


ORA-14500: LOCAL option not valid without partition name

1 Answers  


ORA-09814: Unable to expand file name

1 Answers  


DRG-13000: error while adding or removing a sub lexer

1 Answers  


DRG-13305: 'off' attribute value must be in the range string..string, at line string

1 Answers  


ORA-01628: max # extents (string) reached for rollback segment string

1 Answers  


Categories