oracle8.1.6
begin
:1 := content_keyword.new (
:heading,
:description,
:parent_id,
:keyword_id,
sysdate(),
:user_id,
:creation_ip,
:object_type,
:package_id
);
end;
begin
content_keyword.del(:keyword_id);
end;
begin
content_keyword.set_heading(:keyword_id, :heading);
end;
begin
content_keyword.item_assign(
:item_id,
:keyword,
null,
null,
null
);
end;
begin
:1 := content_symlink.new (
name => :name,
target_id => :target_id,
label => :label,
parent_id => :parent_id,
symlink_id => :symlink_id,
creation_user => :creation_user,
creation_ip => :creation_ip,
package_id => :package_id
);
end;
begin
content_symlink.del (
symlink_id => :symlink_id
);
end;
select content_symlink.is_symlink (:item_id)
from dual
select content_symlink.resolve (
:item_id
) from dual
select content_symlink.resolve_content_type (
:item_id
) from dual
, content.blob_to_string(content) as text
select 't' from cr_revisions r, cr_items i
where r.revision_id = :revision_id
and i.item_id = r.item_id
and ((r.content is not null and i.storage_type in ('lob','text')) or
(r.filename is not null and i.storage_type = 'file'))
begin
:1 := content_extlink.new (
name => :name,
url => :url,
label => :label,
description => :description,
parent_id => :parent_id,
extlink_id => :extlink_id,
creation_user => :creation_user,
creation_ip => :creation_ip,
package_id => :package_id
);
end;
begin
content_extlink.del (
extlink_id => :extlink_id
);
end;
select content_extlink.is_extlink (:item_id)
from dual
select
0 as tree_level, '' as name , 'Home' as title
from
dual
UNION
select
t.tree_level, i.name, content_item.get_title(t.context_id) as title
from (
select
context_id, level as tree_level
from
acs_objects
where
context_id <> content_item.get_root_folder
connect by
prior context_id = object_id
start with
object_id = :item_id
) t, cr_items i
where
i.item_id = t.context_id
order by
tree_level
begin
content_folder.delete(:folder_id);
end;