Re: exception problem

java4dev <java4dev@gmail.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