Hi AT Team

I am tasked with maintaining similar code below.
The function returns a description from a state
code table.

The exception NO_DATA_FOUND is coded to do a RAISE.

When I test the function with a "bad" state code
value, the select from DUAL works, one empty row
is returned in TOAD.

There is a return coded with a NVL which will not
be executed when the NO_DATA_FOUND exception occurs.

When I code a query using the function against a
table with both good and bad (or missing) state code
values the query works returning descriptions for the
good state codes and null for the bad state codes.

What does the RAISE accomplish?

Thank you
Charles

---------------------------------------

select get_state_name('ZZ') from dual;

---------------------------------------

create function get_state_name 
       (p_state_cd_in in varchar2) 
       return varchar2 
    is
    ---- Variables
         v_state_name     varchar2(50) := null;
begin
   select   state_name 
     into   v_state_name
     from   state
    where   state_cd = p_state_cd_in
      and   rownum   < 2;

   return   nvl(v_state_name,'NA');

exception
   when no_data_found 
   then raise;
end get_state_name;

exception
  when ANY_EX then raise;

create or replace function f ( p varchar2 ) 
  return int as
  retval int;
begin

  select 1 
  into   retval
  from   dual
  where  dummy = p;
  
  return retval;

end f;
/

var v varchar2(1);

exec :v := f ( 'Y' );

ORA-01403: no data found

select f ( 'Y' ) from dual;

F('Y')   
   <null>