Subject change the text of exception
Author Sergio H. Gonzalez
Hello, is there a way to change the text of an exception before rise it?
I have a stored proc which performs a task on every article of the article's
table, with some validation. I would like to show the user what article rised
the exception. Now I have this:

CREATE EXCEPTION
DETALLE_COSTO_0
'There are *Imported* articles with Cost Detail = 0';

And then inside the SP:

CREATE PROCEDURE COSTO_ARTICULO (id integer)
returns (ncosto numeric(14,3))
as
begin

[...]

if (*SOME_CONDITION*) then
begin
exception detalle_costo_0;
end

end