Oracle Error ORA-30002: SYS_CONNECT_BY_PATH function is not allowed here

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.