Index: openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql 28 Aug 2001 23:31:30 -0000 1.4 +++ openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql 2 Sep 2001 15:15:57 -0000 1.5 @@ -85,6 +85,7 @@ v_rel_id acs_objects.object_id%TYPE; v_rel_tag cr_child_rels.relation_tag%TYPE; v_context_id acs_objects.context_id%TYPE; + v_storage_type cr_items.storage_type%TYPE; begin -- if content_item.is_subclass(item_subtype,'content_item') = 'f' then @@ -95,6 +96,12 @@ -- place the item in the context of the pages folder if no -- context specified + if storage_type = 'text' then + v_storage_type := 'lob'; + else + v_storage_type := storage_type; + end if; + if parent_id is null then v_parent_id := c_root_folder_id; else @@ -168,7 +175,7 @@ item_id, name, content_type, parent_id, storage_type ) values ( v_item_id, content_item.new.name, - content_item.new.content_type, v_parent_id, content_item.new.storage_type + content_item.new.content_type, v_parent_id, v_storage_type ); -- if the parent is not a folder, insert into cr_child_rels