We found another error that caused havoc in Edit this page.
It is in /web/myserver/packages/edit-this-page/sql/oracle/edit-this-page-create.sql
We replaced these lines (68-81) ...
function get_attribute_value (
object_id in acs_objects.object_id%TYPE,
attribute_id in acs_attribute_values.attribute_id%TYPE
) return varchar is
v_value acs_attribute_values.attr_value%TYPE;
begin
select attr_value
into v_value
from acs_attribute_values
where object_id = object_id
and attribute_id = attribute_id;
return v_value;
exception when no_data_found then return null;
end get_attribute_value;
... with these ...
function get_attribute_value (
object_id in acs_objects.object_id%TYPE,
attribute_id in acs_attribute_values.attribute_id%TYPE
) return varchar is
v_value acs_attribute_values.attr_value%TYPE;
begin
select attr_value
into v_value
from acs_attribute_values
where object_id = get_attribute_value.object_id
and attribute_id = get_attribute_value.attribute_id;
return v_value;
exception when no_data_found then return null;
end get_attribute_value;
I'm now working with the package and it seems (knock on wood) to work fine in an Oracle 8.1.6 & OpenACS 4.6.3 environment.
Harish and Malte, I'm still interested in other changes you made to the package including the new functionalties like the sliding menu.
