etp-setup-2-oracle.xql

DB Query file

Related Files

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>
<queryset>
   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>

<fullquery name="create_folder">
<querytext>
   begin
     :1 := content_folder.new(
              name        => :name,
              label       => :title,
              description => '',
              parent_id   => etp.get_folder_id(:parent_package_id)
           );
   end;
</querytext>
</fullquery>

<fullquery name="register_types">
    <querytext>
    begin
      content_folder.register_content_type(
      folder_id => :folder_id,
      content_type => 'content_revision',
      include_subtypes => 't'
      );
    end;
    </querytext>
</fullquery>

<fullquery name="register_folders">
    <querytext>
    begin
      content_folder.register_content_type(
      folder_id => :folder_id,
      content_type => 'content_folder',
      include_subtypes => 'f');
    end;
    </querytext>
</fullquery>

<fullquery name="get_section_name">
<querytext>
   select acs_object.name(:package_id) as title from dual
</querytext>
</fullquery>

</queryset>