Special cases (2)
uAlter session/system/database…
create procedure p_dropFBIndex (i_index_tx)is
Begin
execute immediate
'ALTER SESSION SET EVENTS ''10624 trace
'||
' name context
forever, level 12''';
execute immediate
'drop index '||i_index_tx;
execute immediate
'ALTER SESSION SET EVENTS ''10624 trace
'||
' name context
off''';
end;
