postgresql7.1
select acs_object__name(:object_id);
select o.object_id,
o.title,
o.package_id,
o.object_type,
o.context_id,
o.security_inherit_p,
o.creation_user,
to_char(o.creation_date, 'YYYY-MM-DD HH24:MI:SS') as creation_date_ansi,
o.creation_ip,
to_char(o.last_modified, 'YYYY-MM-DD HH24:MI:SS') as last_modified_ansi,
o.modifying_user,
o.modifying_ip,
o.tree_sortkey,
acs_object__name(o.object_id) as object_name
from acs_objects o
where o.object_id = :object_id