Oracle Error ORA-30004: when using SYS_CONNECT_BY_PATH function, cannot have separator as part of column value

Oracle Error Message

ORA-30004: when using SYS_CONNECT_BY_PATH function, cannot have separator as part of column value

Reason for the Error

A column value contained the string that the SYS_CONNECT_BY_PATH function was to use to separate column values.

Solution

Specify another separator for the SYS_CONNECT_BY_PATH function to use which does not occur in any column value, then retry.