Thursday, May 9, 2013
If you are using asynchronous requests to upload data into an APEX_COLLECTION, you will end up with an ORA-00001: unique constraint violated (APEX_040100.WWV_FLOW_COLLECTION_MEMBERS_PK). The reason is simple, sometimes APEX tries to insert the same value (WWV_FLOW_COLLECTION_MEMBERS$.SEQ_ID). A workaround consist of managing queues on the server side.
Friday, February 15, 2013
This is not APEX or work related ...