For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
select SERVICE_name into :p20_service_name from new_service where service_id=(SELECT max(service_id) from NEW_SERVICE);