filter-procs-oracle.xql

DB Query file

Related Files

• packages/acs-content-repository/tcl/filter-procs.xql
• packages/acs-content-repository/tcl/filter-procs.tcl
• packages/acs-content-repository/tcl/filter-procs-postgresql.xql
• packages/acs-content-repository/tcl/filter-procs-oracle.xql

[ 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="content::get_content_value.gcv_get_revision_id">
	<querytext>

	  begin
	    content_revision.to_temporary_clob(:revision_id);
	  end;

	</querytext>
</fullquery>

<fullquery name="content::get_content_value.gcv_get_previous_content">
	<querytext>

    select 
      content
    from 
      cr_content_text
    where 
      revision_id = :revision_id

	</querytext>
</fullquery>

<fullquery name="content::init.get_template_url">      
      <querytext>

        select 
          content_item.get_live_revision(content_item.get_template(:item_id, :context)) as template_id,
          content_template.get_path(content_item.get_template(:item_id, :context), :template_root) as template_url 
        from 
          dual

      </querytext>
</fullquery>


</queryset>