Forum OpenACS Development: Re: acs_message__new

Collapse
2: Re: acs_message__new (response to 1)
Posted by Iuri Sampaio on
So far, i tracked down the error and fixed on my source code.

The bug is in the source code of acs-kernel version 5.5 and 5.6 (if not also on HEAD) within the file /acs-kernel/sql/postgresql/apm-create.sql line 1537

The error is in the select query in the line 1549:

"and parameter_id = get_value__parameter_id"

when it must be "and parameter_id = v_parameter_id" instead

You can take a look at the psql function from /api-doc

/api-doc/plsql-subprogram-one?type=FUNCTION&name=apm__get_value

create or replace function apm__get_value(int4,varchar) returns varchar as '
1:declare
2: get_value__package_id alias for $1;
3: get_value__parameter_name alias for $2;
4: v_parameter_id apm_parameter_values.parameter_id%TYPE;
5: value apm_parameter_values.attr_value%TYPE;
6:begin
7: v_parameter_id := apm__id_for_name (get_value__package_id, get_value__parameter_name);
8:
9: select attr_value into value from apm_parameter_values v
10: where v.package_id = get_value__package_id
11: and parameter_id = get_value__parameter_id;
12:
13: return value;
14:
15:end;' language 'plpgsql';

cheers,