Related question...
I have a query given to me by Automic that will list all of the folder paths of an object.
select path from
(select level
,ofs_oh_idnr_f as parent
,ofs_oh_idnr_o as child
,oh_name
,substr(oh_name,10,99)
,SYS_CONNECT_BY_PATH( substr(oh_name,10,99) , '/' ) as path
,ofs.ofs_link
from ofs, oh
where oh.oh_idnr = ofs_oh_idnr_f
and ofs_oh_idnr_o = (select oh_idnr from oh where oh_name = 'UC0.MAL.TEST1#1.JOBI')
start with ofs_oh_idnr_f = (select oh_idnr from oh where oh_otype = 'CLNT' and oh_client = 110)
connect by prior ofs_oh_idnr_o = ofs_oh_idnr_f) where ofs_link = 1;
As configured now, with the 'where ofs_link=1' predicate, it will list only the locations of links, and not the object’s home folder.
The problem I am running into now is that I have begun to encounter some situations wherein the path returned by this query contains backslash characters. E.g., the object UC0.MAL.TEST1#1.JOBI has exactly one link, located in
'/APPS/UC0/MAL/TEST1/1/2'. However, the path returned by the query is '/APPS/UC0/MAL/TEST1#A/\1/\2'. Note that the backslashes prefix only the two deepest levels in the folder hierarchy.
I have only begun to see this problem recently, in the past month or so. It never happened before. Any ideas?