Ask a Question
Advertise on boostr.in
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.
Sys_Connect_By_Path(myVariable || ':' || mySecondVariable, ' --> ') "myNewVar",
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.
Oct 7, 2015
to add a comment.
Related Hot Questions
Government Jobs Opening