On Mon, Mar 26, 2007 at 09:38:07PM +0200, Alain Roger wrote:
> Hi,
>
> I wrote a function which should update a table field.
> However, i would like somehow to control that update was done.
> for that i was thinking to return a boolean : true is update was done, false
> if an error happened.
I be
roger-
you need an exception block as in...
CREATE OR REPLACE FUNCTION sp_a_005("login" "varchar", pwd "varchar")
RETURNS boolean AS
$BODY$
BEGIN
UPDATE...
EXCEPTION
WHEN NO_DATA_FOUND
RETURN FALSE
WHEN PROGRAM_ERROR
RETURN FALSE
WHEN OTHERS
RETURN FALSE
RETURN TRUE
END;
-
