Re: Raise exception in the function that used in a select.

From: Keith Boulton <boulke_at_globalnet.co.uk>
Date: Mon, 22 Nov 1999 17:36:21 GMT
Message-ID: <38396841.2387314@read.news.globalnet.co.uk>

On 22 Nov 1999 09:03:09 GMT, "Lev Yunak" <L.Yunak_at_vaz.ru> wrote:

>This problem isn't funny. I really need to sovle it.
>
>I want to raise exception in fucntion like
>
>function test(...) return number is
>begin
> ...
> raise_application_error(-20800, 'Error because lalala');
> ...
>end;
>
>AND use it in a select like
>
>select test(...) from dual
>

This works ok in 8i. I do not think it is possible in earlier versions because raise_application_error issues a rollback. You will have to modify you client application to map error numbers onto meaningful messages I think. Received on Mon Nov 22 1999 - 11:36:21 CST