At 07:39 PM 4/12/2007, you wrote:

>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?

It would help if you would provide the actual error that is returned.

Any foreign keys involved?

./heLen