Oracle_scripte/Tanel/demos/self_deadlock_ora_4020.sql
2014-09-17 13:23:48 +02:00

12 lines
172 B
SQL

DROP PROCEDURE p1;
DROP PROCEDURE p2;
CREATE OR REPLACE PROCEDURE p1 AS BEGIN P2; END;
/
CREATE OR REPLACE PROCEDURE p2 AS BEGIN P1; END;
/
ALTER PROCEDURE p1 COMPILE;