java4dev <java4dev(at)gmail(dot)com> writes:
> SELECT is_unlocked INTO v_is_unlocked
> FROM aaa.domains
> WHERE pk_domain_id = p_domain_id;
> RETURN v_is_unlocked;
> EXCEPTION
> WHEN TOO_MANY_ROWS THEN
> RETURN FALSE;
> WHEN NO_DATA_FOUND THEN
> RETURN FALSE;
Perhaps you want "if found then return v_is_unlocked; else return false;
end if;" in there. Or if you really want to do it as above, you need to
say SELECT INTO STRICT to have those exceptions be thrown. See the
manual.
regards, tom lane