Subject Exception hangling in stored procedure
Author tomkrej
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.

Is it correct behavior? 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, ...)

Thank You in advance, Tom