Unusual Primary Key Constraint violation
476328Jun 20 2007 — edited Sep 5 2011When using Apex collections from time to time this unique constraint error happens.
ORA-00001: unique constraint (FLOWS_030000.WWV_FLOW_COLLECTIONS_UK) violated
Now, I can't figure out why this constraint would be happening as we check for the existence of a collection before trying to create one, and the constraint relies on a number of values which we can't modify.
All of our collection operations are done using the following APEX_COLLECTION calls
COLLECTION_MEMBER_COUNT
COLLECTION_EXISTS
CREATE_OR_TRUNCATE_COLLECTION
ADD_MEMBER
DELETE_MEMBERS
As I don't modify any data inside of the collections using any methods other than these above API calls I'm a bit confused.
It's almost impossible for me to reproduce the error as it happens very rarely, in addition, most of the time performing the same action again after the constraint error has happened will succeed.
Any ideas what I might be doing that could cause this?
Thanks in advance,
Joe