tomkrej schrieb am 26.11.2010 um 10:07 (-0000):

> Hi, I find some manuals for exception handling using WHEN
>
> in some of them there is an initialization of output parameter in WHEN
> block. I tried to do it in my database, but when I call the procedure
> like
>
> select * from procedure_with_when (:param1, :param2)
>
> and the exception is raised, the result is empty. no value is
> returned.

Might you be missing to call SUSPEND? You should post your code.

> I had an idea that one of output parameters would inform whether the
> operation was successfull, or when not, why not(e.g. 0 = success, -1 =
> error 1, -2 = error 2, ...)

That's certainly possible.

--
Michael Ludwig