Dynamic SQL in a Dynamic World

Special cases (1)

uDDL

ØImplicit COMMITs à autonomous transactions are strongly recommended.

ØThere is a chance that it will lock itself.

create procedure p_drop_procedure

(i_proc_tx VARCHAR2) is

pragma autonomous_transaction;

begin

execute immediate
'drop procedure '||i_proc_tx;

end;