Hi,

With Firebird 1.5 and up, you can write:

exception detalle_costo_0 'new text';

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

> 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
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>