oracle8.1.6
declare
begin
:1 := dotlrn_community_type.new(
community_type => :community_type_key,
parent_type => :parent_type,
pretty_name => :pretty_name,
pretty_plural => :pretty_name,
description => :description
);
end;
declare
begin
:1 := dotlrn_community.new(
community_type => :community_type,
community_key => :name
pretty_name => :pretty_name,
pretty_plural => :pretty_name,
description => :description
);
end;
declare
begin
dotlrn_community.set_active_dates(
community_id => :community_id,
start_date => to_date(:start_date, :date_format),
end_date => to_date(:end_date, :date_format)
);
end;
select site_node.url(node_id)
from site_nodes
where parent_id = :current_node_id
and object_id= :package_id
select site_node.url(node_id)
from site_nodes
where object_id = :package_id
select community_type
from dotlrn_communities
where community_id = :community_id
select object_type
from acs_object_types
where supertype = 'dotlrn_community'
start with object_type = (select community_type
from dotlrn_communities
where community_id = :community_id)
connect by object_type = prior supertype