Oracle Error Message
ORA-30002: SYS_CONNECT_BY_PATH function is not allowed here
Reason for the Error
SYS_CONNECT_BY_PATH function was called at places other than the SELECT list and ORDER BY clause.
Solution
Remove calls to SYS_CONNECT_BY_PATH function at places other than the SELECT list and ORDER BY clause.
