create or replace procedure last_country (c_code out varchar2, c_name out varchar2) as row rowid; begin select max(rowid) into row from country; select country_code, country_name into c_code, c_name from country where rowid = row; exception when no_data_found then raise_application_error(-20101,'Record does not exist'); null; end; /