oracle8.1.6
begin
:1 := content_item.get_id(
item_path => :item_name,
root_folder_id => :parent_id,
resolve_index => 'f');
end;
select nvl (cr.content_length,0) as content_length,
nvl (cr.mime_type,'*/*') as mime_type,
to_char(o.creation_date, 'YYYY-MM-DD"T"HH:MI:SS."000"') as creation_date,
to_char(o.last_modified, 'Dy, Dd Mon YYYY HH:MI:SS "${os_time_zone}"') as last_modified,
ci1.item_id,
case when ci1.item_id=:folder_id then '' else ci1.name end as name,
content_item.get_path(ci1.item_id,:folder_id) as item_uri,
case when o.object_type='content_folder' then 1 else 0 end
as collection_p
from (
select * from cr_items
where (parent_id=:folder_id
or item_id=:folder_id)
and level <= :depth + 1
connect by prior item_id=parent_id
start with item_id=:folder_id
) ci1,
cr_revisions cr,
acs_objects o
where
ci1.item_id=o.object_id
and ci1.live_revision = cr.revision_id(+)
and exists (select 1
from acs_object_party_privilege_map m
where m.object_id = ci1.item_id
and m.party_id = :user_id
and m.privilege = 'read')
select
ci.item_id,
ci.name,
content_item__get_path(ci.item_id,:folder_id) as item_uri,
coalesce(cr.mime_type,'*/*') as mime_type,
cr.content_length,
to_char(o.creation_date, 'YYYY-MM-DD"T"HH:MM:SS.MS"Z"') as creation_date,
to_char(o.last_modified, 'Dy, DD Mon YYYY HH:MM:SS TZ') as last_modified
from cr_items ci,
acs_objects o,
cr_revisions cr
where
ci.item_id=:item_id
and ci.item_id = o.object_id
and cr.revision_id=ci.live_revision
begin
:1 := content_folder.new(
name => :new_folder_name,
label => :label,
description => :description,
parent_id => :parent_id,
context_id => :parent_id,
folder_id => NULL,
creation_date => sysdate,
creation_user => :user_id,
creation_ip => :peer_addr
);
end;
begin
:1 := content_folder.copy (
folder_id => :copy_folder_id,
target_folder_id => :new_parent_folder_id,
creation_user => :user_id,
creation_ip => :peer_addr,
name => :new_name
);
end;
begin
:1 := content_folder.move (
folder_id => :move_folder_id,
target_folder_id => :new_parent_folder_id,
name => :new_name
);
end;
begin
content_folder.rename (
folder_id => :move_folder_id,
name => :new_name,
label => NULL,
description => NULL
);
end;
begin
content_item.move (
item_id => :item_id,
target_folder_id => :new_parent_folder_id,
name => :new_name
);
end;
begin
content_item.rename (
item_id => :item_id,
name => :new_name
);
end;
begin
:1 := content_item.copy2 (
item_id => :copy_item_id,
target_folder_id => :new_parent_folder_id,
creation_user => :user_id,
creation_ip => :peer_addr,
name => :new_name
);
end;
begin
content_item.del(
item_id => :dest_item_id
);
end;
begin
content_item.del(
item_id => :dest_item_id
);
end;
begin
content_item.del (
item_id => :item_id
);
end;
begin
content_folder.del (
folder_id => :item_id,
cascade_p => 't'
);
end;
begin
:1 := content_item.get_id(
item_path => :parent_name,
root_folder_id => :root_folder_id,
resolve_index => 'f');
end;
select content_item.get_id(:new_name,:new_parent_folder_id,'f') from dual
select content_item.get_id(:new_name,:new_parent_folder_id,'f') from dual
begin
content_folder.del(
folder_id => :dest_item_id,
cascade_p => 't');
end;
begin
content_folder.del(
folder_id => :dest_item_id,
cascade_p => 't');
end;
select content_item.get_id(:new_name,:new_parent_folder_id,'f') from dual
select content_item.get_id(:new_name,:new_parent_folder_id,'f') from dual