NO NO_DATA_FOUND ?!?!

The function

 create function noex
 return number
 as

    n number;
 begin

    select 1 into n from dual where 0=1;     n := 4; -- not executed!
    return n;
 end;

should raise an NO_DATA_FOUND exception in my opinion. It answers NULL however and ignores the rest of body code. The example concerns pl/sql functions in general.

I need tho catch NO_DATA_FOUND in pl/sql function. What to do?

Marcin. Received on Tue May 15 2001 - 03:12:18 CDT