Organizational Research By

Surprising Reserch Topic

oracle ora 30004 when using sys connect by path function


oracle ora 30004 when using sys connect by path function  using -'oracle'

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 Text
SomeText 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.
    
asked Oct 7, 2015 by bhavin
0 votes
28 views



Related Hot Questions



Government Jobs Opening


...