oracle8.1.6
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)