Fix dropped synonyms counter.

kukimik · web-flow · commit 4e82973abad2 · 2022-08-08T14:55:49.000+02:00
diff --git a/source/uninstall_synonyms.sql b/source/uninstall_synonyms.sql
@@ -15,10 +15,10 @@ begin
         and not exists (select 1 from all_objects o where o.owner = s.table_owner and o.object_name = s.table_name)
   )
   loop
-    i := i + 1;
     begin
       execute immediate 'drop '||syn.syn_name;
       dbms_output.put_line('Dropped '||syn.syn_name||' for object '||syn.for_object);
+      i := i + 1;      
       exception
       when others then
       dbms_output.put_line('FAILED to drop '||syn.syn_name||' for object '||syn.for_object);
