ORA-30004 when using SYS_CONNECT_BY_PATH function, cannot have seperator as part of the column
Action: Use another seperator which does not occur in any column value, then retry.
Error on:
select ...
Sys_Connect_By_Path(myVariable || ':' || mySecondVariable, ' --> ') "myNewVar",
...
Works:
select ...
Sys_Connect_By_Path(myVariable || ':' || mySecondVariable, ' -> ') "myNewVar",
...
In the data we found some text like this
SomeText B--More TextSomeText A--More Text
Since there is no '-->' or for that mater no '-->' in the data why does the first one error? The second one has a space in front and on the end.