oracle 8.1.6 insert into ec_problems_log (problem_id, problem_date, problem_details) values (ec_problem_id_sequence.nextval, sysdate,:prob_details ) update ec_gift_certificates set user_id=:user_id, claimed_date=sysdate where gift_certificate_id=:gift_certificate_id insert into ec_problems_log (problem_id, problem_date, gift_certificate_id, problem_details) values (ec_problem_id_sequence.nextval, sysdate, :gift_certificate_id, :prob_details)