oracle8.1.6
select
1 as element_exists_p,
controlling_portal_id,
decode(acs_permission.permission_p(:element_id, :user_id, 'read'), 't', 1, 'f', 0) as element_write_p
from portal_elements
where element_id = :element_id
declare
eid portal_elements.element_id%TYPE;
begin
eid := portal_element.new (
element_id => :element_id,
name => :name,
description => :description,
exportable_p => :exportable_p,
datasource_id => :datasource_id,
template_id => :template_id,
controlling_portal_id => :default_portal_id
);
end;
begin
portal_element.make_available( element_id => :element_id, portal_id => :default_portal_id );
end;