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-08231: smscre: unable to attach to SGA

1 Answers  


ORA-00227: corrupt block detected in controlfile: (block string, # blocks string)

1 Answers  


ORA-27074: unable to determine limit for open files

1 Answers  


ORA-40215: model string is incompatible with current operation

1 Answers  


EXP-00095: Flashback_time and Flashback_scn are not compatible

1 Answers  






ORA-23450: flavor already contains object "string"."string"

1 Answers  


DRG-11222: Third-party filter does not support this known document format.

1 Answers  


TNS-12216: TNS:poorly formed PREFERRED_CMANAGERS addresses in TNSNAV.ORA

1 Answers  


NNL-00857: Total rename processing time: string

1 Answers  


ORA-25467: table alias not specified

1 Answers  


ORA-29803: missing ANCILLARY keyword

1 Answers  


ORA-30190: reserved for future use

1 Answers  


Categories