OpenACS

This fixes the following bug for Oracle:

': ORA-00920: invalid relational operator

:

:    SQL:

:        select p.package_id,

:               p.instance_name,

:               n.node_id,

:               n.name

:        from   site_nodes n,

:               apm_packages p,

:               apm_package_types t

:        where  n.parent_id = :subsite_node_id

:        and    p.package_id = n.object_id

:        and    t.package_key = p.package_key

:        and    t.package_type = 'apm_application'

:        and    acs_permission.permission_p(p.package_id, :user_id, 'read')

:        !>>>!order  by upper(instance_name)

:

Show less