Greetings all,



I have a strange issue where it seems that a simple INSERT statement is
getting stuck behind locks. The statement in question is as follows:



INSERT INTO ITEMS (GUID, LOADGUID, RFE, QTY, INCPALLET, CISTATUS,
PRODUCTID)

VALUES (:GUID, :LOADGUID, :RFE, :QTY, :INCPALLET, :STATUS, :PRODUCTID)



There's one Before Insert trigger on the table, but the only thing that
does is:



If (new.GUID is null) then new.GUID = gen_uuid();



This is the only statement in the transaction and the transaction has
concurrent mode without auto-commit or auto-undo.



Could anybody tell me what might be locking this statement and what I
could do to prevent this?



Regards,



Mathias



[Non-text portions of this message have been removed]