postgresql
7.1
select ec_issue_id_sequence.nextval
insert into ec_customer_serv_interactions
(interaction_id, customer_service_rep, user_identification_id, interaction_date, interaction_originator, interaction_type, interaction_headers)
values
(:interaction_id, :customer_service_rep, :user_identification_id, current_timestamp, :interaction_originator, :interaction_type, :interaction_headers)
insert into ec_customer_service_issues
(issue_id, user_identification_id, order_id, open_date, close_date, closed_by, gift_certificate_id)
values
(:issue_id, :user_identification_id, :order_id, current_timestamp, current_timestamp, :customer_service_rep, :gift_certificate_id)