akkerend,

I changed the line to

DBMS_UTILITY.EXEC_DDL_STATEMENT('ALTER TABLE TEST ADD (QQQ VARCHAR2 (50))');

but i still get the deadlock error for the first run, second run is fine.


SQL> start patch
Task is complete, old version = 6
DECLARE
*
ERROR at line 1:
ORA-04020: deadlock detected while trying to lock object PPDBA.TEST
ORA-06512: at "SYS.DBMS_SYS_SQL", line 487
ORA-06512: at "SYS.DBMS_SQL", line 32
ORA-06512: at "SYS.DBMS_UTILITY", line 332
ORA-06512: at line 10


SQL> start patch




Task is complete, old version = 6
Task is complete, new version = 7.1

PL/SQL procedure successfully completed.

7.1

7.1

SQL>