Lost Objects in left hand tree view

WCLucas42

Member
I have a nested case statement that I am using that looks like this (Hope it doesn't look too bad).

SELECT XMLAGG(XMLELEMENT("UnarchiveStatus",
XMLELEMENT("Success",
'1'),
XMLELEMENT("ArchiveExists",
CASE
WHEN recArchive.ItemTable= eEQUIPMENT.EnumValue THEN CASE
WHEN (SELECT COUNT(*)
FROM tblEquipment
WHERE UPPER(StatusID) = UPPER(recArchive.ArchiveID)) > 0 THEN 1
ELSE 0
END
WHEN recArchive.ItemTable = eHistories.EnumValue THEN CASE WHEN (SELECT COUNT(*)
FROM tblHistories
WHERE UPPER(StatusID) = UPPER(recArchive.ArchiveID)) > 0 THEN 1
ELSE 0
END
END)))
INTO XMLTemp
FROM DUAL;

When I use this code any procedures or functions below this code are lost in the object tree on the left hand side of the program window. I have rewritten the code to prevent this but just thought I would ask if anyone else has had a similar problem, or if there will be a fix for this. I can provide the package code for further review.

Thanks,
Bill
 
This is fixed in 5.1.3 (available early next week).

------------------
Marco Kalter
Allround Automations
 
Back
Top