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) select i.issue_id, i.open_date, i.close_date, m.issue_type from ec_customer_service_issues i, ec_cs_issue_type_map m, ec_user_identification id where i.issue_id = m.issue_id(+) and i.user_identification_id = id.user_identification_id and id.user_id = :user_id order by i.issue_id select i.issue_id, i.open_date, i.close_date, m.issue_type from ec_customer_service_issues i, ec_cs_issue_type_map m where i.issue_id = m.issue_id(+) and i.user_identification_id = :user_identification_id order by i.issue_id