Fixed examples and added examples to main examples run.

jgebal · jgebal · commit 91fd6387db88 · 2016-12-14T00:28:54.000Z
diff --git a/examples/RunAllExamples.sql b/examples/RunAllExamples.sql
@@ -23,3 +23,13 @@ prompt RunExpectations
 @@RunExpectations.sql
 prompt RunWithDocumentationReporter
 @@RunWithDocumentationReporter.sql
+
+@@award_bonus/run_award_bonus_test.sql
+--workaround for suite level cache
+declare d date := sysdate; begin loop exit when d != sysdate; end loop; end;
+/
+@@between_string/run_betwnstr_test.sql
+--workaround for suite level cache
+declare d date := sysdate; begin loop exit when d != sysdate; end loop; end;
+/
+@@remove_rooms_by_name/run_remove_rooms_by_name_test.sql
diff --git a/examples/award_bonus/run_award_bonus_test.sql b/examples/award_bonus/run_award_bonus_test.sql
@@ -1,4 +1,4 @@
-@@employees.sql
+@@employees_test.sql
 @@award_bonus.sql
 @@test_award_bonus.pkg
 
diff --git a/examples/award_bonus/test_award_bonus.pkg b/examples/award_bonus/test_award_bonus.pkg
@@ -35,7 +35,7 @@ create or replace package body test_award_bonus as
         from employees_test where employee_id = gc_test_employee;
 
     open not_affected for
-      select * from employees where employee_id <> gc_test_employee;
+      select * from employees_test where employee_id <> gc_test_employee;
 
     --act
     award_bonus(emp_id => gc_test_employee, sales_amt => c_sales_amount);
diff --git a/examples/remove_rooms_by_name/run_remove_rooms_by_name_test.sql b/examples/remove_rooms_by_name/run_remove_rooms_by_name_test.sql
@@ -4,7 +4,7 @@
 
 set serveroutput on size unlimited format truncated
 
-exec ut.run(user||'.test_betwnstr',ut_documentation_reporter());
+exec ut.run(user||'.test_remove_rooms_by_name',ut_documentation_reporter());
 
 drop package test_remove_rooms_by_name;
 drop procedure remove_rooms_by_name;

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-@@employees.sql`
	`1`	`+@@employees_test.sql`
`2`	`2`	`@@award_bonus.sql`
`3`	`3`	`@@test_award_bonus.pkg`
`4`	`4`