Re: Problems with NULL value in SP on 7.3 NT
> create procedure if_null(what int) returning int;> if what is null
> then return 0;
> else return what;
>
> end if;
> end procedure;
>
> And now lets call it:
>
> execute procedure if_null(null)>
> In 7.2x its returns 0,
> in 7.3 it tells the following error:
> SQL Error (-696) variable (what ) has undefined value
Try:
create procedure if_null(what int default null) returning int; ^^^^^^^^^^^^
if what is null
then return 0;
else return what;
end if;
end procedure;