oracle8.1.6
begin
content_type.register_template(
content_type => :content_type,
template_id => :template_id,
use_context => :context );
end;
select
template_id,
content_item.get_path( template_id, content_template.get_root_folder )
as name
from
cr_templates t, cr_items i
where
t.template_id = i.item_id
and not exists (
select 1
from
cr_type_template_map
where
template_id = t.template_id
and
content_type = :content_type )
and
$marked_templates_sql