oracle8.1.7 delete from aa_test_results where testcase_id = :testcase_id delete from aa_test_final_results where testcase_id = :testcase_id insert into aa_test_results (testcase_id, package_key, test_id, timestamp, result, notes) values (:aa_testcase_id, :aa_package_key, :aa_testcase_test_id, sysdate, :test_result, :test_notes) insert into aa_test_final_results (testcase_id, package_key, timestamp, passes, fails) values (:aa_testcase_id, :aa_package_key, sysdate, :test_passes, :test_fails)