ora-02049 timeout distributed transaction waiting for lock

Hi,

I have observed the following scripts

Indicating that recurrently are being presented object locking

I have suggested review those scripts

and review the objects that have unused code (LOCK TABLE IN EXCLUSIVE MODE)

--DELETE O.TP_ESQUELA WHERE NU_EXPE =:"SYS_B_0" AND NU_SOLI =:"SYS_B_1" AND NU_ESQU =:"SYS_B_2"

--DELETE O.TP_ESQUELA WHERE NU_EXPE =:"SYS_B_0" AND NU_SOLI =:"SYS_B_1" AND TI_DOCU IN ( :"SYS_B_2" , :"SYS_B_3" )

--INSERT INTO O.TP_ESQUELA ( NU_ESQU, CO_CNTA_PENS, FE_ESQU, ES_ESQU, NU_EXPE, NU_SOLI, TI_DOCU, FE_ULTI_MODI, CO_USUA_MODI, FE_PROC ) VALUES (:B5 , :B4 , SYSDATE, 'RE', :B3 , :B2 , :B1 , SYSDATE, USER, SYSDATE)