publish-procs-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="publish::handle::text.get_revision_id">
      <querytext>

                begin
                content_revision.to_temporary_clob(:revision_id);
                end;

      </querytext>
</fullquery>

<fullquery name="publish::handle::text.get_previous_content">
      <querytext>

                       select
                         content
                       from
                         cr_content_text
                       where
                         revision_id = :revision_id

      </querytext>
</fullquery>

<fullquery name="publish::write_multiple_blobs.wmb_get_blob_file">
      <querytext>
        select [expr {$storage_type eq "file" ? "'[cr_fs_path]' || filename" : "content"}]
          from cr_revisions where revision_id = :revision_id
      </querytext>
</fullquery>


<fullquery name="publish::write_content.get_previous_content">
      <querytext>

                       select
                         content
                       from
                         cr_content_text
                       where
                         revision_id = :revision_id

      </querytext>
</fullquery>

</queryset>