oracle8.1.6 begin :1 := portal.new ( name => :name, layout_id => :layout_id, template_id => :template_id, default_page_name => :default_page_name, default_accesskey => :default_accesskey, theme_id => :theme_id, context_id => :context_id ); end; begin portal.del(portal_id => :portal_id); end; insert into portal_element_parameters (parameter_id, element_id, config_required_p, configured_p, key, value) select acs_object_id_seq.nextval, :new_element_id, config_required_p, configured_p, key, value from portal_element_parameters where element_id = :template_element_id insert into portal_element_parameters (parameter_id, element_id, config_required_p, configured_p, key, value) select acs_object_id_seq.nextval, :new_element_id, config_required_p, configured_p, key, value from portal_datasource_def_params where datasource_id= :ds_id insert into portal_element_parameters (parameter_id, element_id, configured_p, key, value) select acs_object_id_seq.nextval, :element_id, 't', :key, :value from dual where not exists (select parameter_id from portal_element_parameters where element_id = :element_id and key = :key and value= :value) begin :1 := portal_page.new( pretty_name => :pretty_name, accesskey => :accesskey, portal_id => :portal_id, layout_id => :layout_id ); end; begin portal_page.del(page_id => :page_id); end;