postgresql
7.1
insert into ec_problems_log
(problem_id, problem_date, problem_details)
values
(ec_problem_id_sequence.nextval, current_timestamp,:prob_details )
update ec_gift_certificates set user_id=:user_id, claimed_date=current_timestamp 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, current_timestamp, :gift_certificate_id, :prob_details)