How to extract document name and its attribute?
I would like to create SQL to show the document name in Livelink and also some attribute of them.Firstly, I used this command and It's work.SELECT a.DataID, b.ID, b.KeyID, a.Name, b.AttrID, b.ValStr, decode(subtype,0,'Folder',144,'Document')FROM DTree a, LLAttrData bWHERE a.DataID = b.ID(+) and b.AttrID = 20 and a.DATAID = 271894But when I used connect by prior statement with this SQL, It isn't work. The reason why I need to add connect by because I would like to select any folder and extract all files and folder under its.SELECT level, a.DataID, b.ID, b.KeyID, lpad(' ', level*2, ' ') || trim(a.name), a.Name, b.AttrID, b.ValStr, decode(subtype,0,'Folder',144,'Document')FROM DTree a, LLAttrData bWHERE a.DataID = b.ID(+) and b.AttrID = 20 start with a.dataid = 110740 connect by prior a.dataid = a.parentidThe error was shown "ORA-00600: internal error code, arguments: [qesmmCValStat4], [3], [1], [], [], [], [], []"Please recommend how to solve this problem?Thanks.
