PROMPT create or replace package sysint

create or replace package sysint
is

	function get_name (
		p_id   in   sys_interface.id%type
	) return sys_interface.name%type;

end sysint;
/

PROMPT create or replace package body sysint 

create or replace package body sysint is

function get_name (
	p_id   in   sys_interface.id%type
) return sys_interface.name%type
is
	result sys_interface.name%type;
begin

	begin
		select
			name
		into
			result
		from
			sys_interface
		where
			id = p_id;

		exception
			when NO_DATA_FOUND then
				result := NULL;
	end;

	return result;

end get_name;

end sysint;
/
