Index: openacs-4/packages/cms/tcl/item-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/cms/tcl/Attic/item-procs-oracle.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/cms/tcl/item-procs-oracle.xql 2 Sep 2001 14:24:58 -0000 1.3 +++ openacs-4/packages/cms/tcl/item-procs-oracle.xql 17 Sep 2001 05:16:40 -0000 1.4 @@ -2,48 +2,7 @@ oracle8.1.6 - - - - - - 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')) - - - - - - - - select content_item.get_best_revision(:item_id) from dual - - - - - - - - - select content_item.get_path(:item_id) from dual - - - - - - - - - select content_item.get_template(:item_id, :context) as template_id - from dual - - - -