select transaction_id, auth_code from authorize_gateway_result_log where txn_attempted_type='AUTH_ONLY' and response_code='1' and transaction_id=:transaction_id insert into authorize_gateway_result_log (transaction_id, txn_attempted_type, txn_attempted_time, response, response_code, response_reason_code, response_reason_text, auth_code, avs_code, amount) values (:transaction_id, :txn_attempted_type, :txn_attempted_time, :response, :response_code, :response_reason_code, :response_reason_text, :auth_code, :avs_code, :amount) select version_name from apm_package_versions where enabled_p = 't' and package_key = 'authorize-gateway' select instance_name from apm_packages p, apm_package_versions v where p.package_key = v.package_key and v.enabled_p = 't' and p.package_key = 'authorize-gateway'