Forum OpenACS Development: Re: Xowiki - Error after umounting instance
I'll move forward debugging the problem. I'll download the latest version of xotcl , then, I'll confirm here if I notice anything new.
In advance, thanks again for the help/support.
CREATE OR REPLACE FUNCTION mandat__new( integer, varchar, varchar ) RETURNS integer AS $$ DECLARE p_mandat_id ALIAS FOR $1; p_code ALIAS FOR $2; p_type_of_transaction ALIAS FOR $3; BEGIN return 1; END; $$ LANGUAGE plpgsql;is loaded as expected, and no error is triggered (but a few warnings about missing argument names). Btw, you should define the function with named parameters as used all over in newer OpenACS versions in the style of
CREATE OR REPLACE FUNCTION mandat__new( p_mandat_id integer, p_type_of_transaction varchar, p_type_of_property varchar ) RETURNS integer AS $$ DECLARE BEGIN return 1; END; $$ LANGUAGE plpgsql;Be aware, that if you are trying multiple variants of a SQL function (like mandat__new), you might have multiple versions of this function defined in you DB, and the the loading process checks, what's in the DB. So, clean up first to avoid confusions.