Following on from this thread relating to incorrect debug session reporting of collections:
1665113
I am encountering more strange behaviour using collections. I hope its my own programming, however I am increasingly led to believe that something is not quite right within the APEX collections implementation.
I am working within a corporate environment, and my application works fine on the local desktop. However when I try and launch the application from within a Citrix Metaframe desktop, the following error INTERMITTENTLY occurs:
ORA-20104: create_collection_from_query_b Error:ORA-20101: Application collection exists
The url used to launch the application is the base url, so am I correct in thinking a new session should be created? This point is moot however, because on load of my application I explicitly delete all collections and the problem still occurs.
Perhaps the problem lies with using the Citrix desktop, however I think it is more likely that the differences in IE versions are part of this problem.
IE (desktop) version: 6.0.2800.1106.xpsp2.050301-1526CO
IE (citrix desktop) version: 6.0.2800.1106CO
So the obvious difference here is that I have XP-SP2 and the Citrix desktop is running 2000 SP4.
The other intermittent error I get is as follows:
ORA-20104: create_collection_from_query_b Error:ORA-00001: unique constraint (FLOWS_020200.WWV_FLOW_COLLECTIONS_UK) violated
The collection exists of one column and it is a GROUP BY query so duplicates are not possible. Is some other internal field acting as the primary key inside a collection? Or is the collection trying to append to the previous collection? Again, I am very confused because all collections are deleted 'on submit', before the new collection is created.
How can I view this 'FLOWS_020200.WWV_FLOW_COLLECTIONS_UK' value?
Can anyone point me in the right direction?