Fixed rerunability of tests

jgebal · jgebal · commit cbe31e52a4e5 · 2018-03-31T11:10:35.000+01:00
diff --git a/test/core/annotations/test_annot_throws_exception.pkb b/test/core/annotations/test_annot_throws_exception.pkb
@@ -7,7 +7,6 @@ is
 
     l_package_spec  varchar2(32737);
     l_package_body  varchar2(32737);
-    l_drop_statment varchar2(32737);
     l_test_results  ut3.ut_varchar2_list;
   begin
     l_package_spec := '
@@ -108,9 +107,6 @@ is
     select * bulk collect into l_test_results from table(ut3.ut.run(('annotated_package_with_throws')));
 
     g_tests_results := ut3.ut_utils.table_to_clob(l_test_results);
-
-    l_drop_statment := 'drop package annotated_package_with_throws';
-    execute immediate l_drop_statment;
   end;
 
   procedure throws_same_annotated_except is
@@ -166,5 +162,13 @@ is
     ut.expect(g_tests_results).to_match('^\s*Givess failure when a exception is expected and nothing is thrown \[[\.0-9]+ sec\] \(FAILED - [0-9]+\)\s*$','m');
     ut.expect(g_tests_results).to_match('nothing_thrown\s*Expected one of exceptions \(-20459, -20136, -20145\) but nothing was raised.');
   end;
+
+
+  procedure drop_test_package is
+    pragma autonomous_transaction;
+  begin
+    execute immediate 'drop package annotated_package_with_throws';
+  end;
+
 end;
 /
diff --git a/test/core/annotations/test_annot_throws_exception.pks b/test/core/annotations/test_annot_throws_exception.pks
@@ -32,5 +32,9 @@ is
   
   --%test(Givess failure when a exception is expected and nothing is thrown)
   procedure nothing_thrown;
+
+  --%afterall
+  procedure drop_test_package;
+
 end;
 /

Original file line number	Diff line number	Diff line change
`@@ -32,5 +32,9 @@ is`
`32`	`32`
`33`	`33`	`--%test(Givess failure when a exception is expected and nothing is thrown)`
`34`	`34`	`procedure nothing_thrown;`
	`35`	`+`
	`36`	`+ --%afterall`
	`37`	`+ procedure drop_test_package;`
	`38`	`+`
`35`	`39`	`end;`
`36`	`40`	`/`