select response_id from ec_canned_responses where one_line = :one_line insert into ec_canned_responses (response_id, one_line, response_text) values (ec_canned_response_id_sequence.nextval, :one_line, :response_text)