oracle 8.1.6 select ec_issue_id_sequence.NEXTVAL from dual 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, sysdate, :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, sysdate, sysdate, :customer_service_rep, :gift_certificate_id)