oracle8.1.6
insert into ec_gift_certificates
(gift_certificate_id, user_id, amount,
expires,
issue_date, issued_by, gift_certificate_state,
last_modified, last_modifying_user, modified_ip_address)
values
(ec_gift_cert_id_sequence.nextval, :user_id, :amount,
$expires_to_insert,
sysdate, :customer_service_rep, 'authorized',
sysdate, :customer_service_rep, '[ns_conn peeraddr]')