1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
Create or replace function lire_erreur (integer) returns varchar AS
$BODY$
DECLARE
p_num ALIAS FOR $1;
libelle varchar(160);
num integer;
BEGIN
--......ici du code non protégé
BEGIN
SELECT INTO num count(*) FROM erreur WHERE id_erreur=p_num;
EXCEPTION
WHEN SUCCESSFUL_COMPLETION THEN
SELECT INTO libelle id_erreur||':'||libelle From erreur Where id_erreur = p_num;
WHEN OTHERS THEN
libelle := p_num||':ERREUR INDEFINIE';
END;
return libelle;
END;
$BODY$
LANGUAGE 'plpgsql' VOLATILE; |