Subject | change the text of exception |
---|---|
Author | Sergio H. Gonzalez |
Post date | 2008-09-16T14:11:53Z |
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
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