patch-add-oracle.xql

DB Query file

Related Files

• packages/bug-tracker/www/patch-add.xql
• packages/bug-tracker/www/patch-add.tcl
• packages/bug-tracker/www/patch-add.adp
• packages/bug-tracker/www/patch-add-postgresql.xql
• packages/bug-tracker/www/patch-add-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="new_patch">
  <querytext>
      begin
        :1 := bt_patch.new(
                patch_id               => :patch_id,
                project_id             => :package_id,
                component_id           => :component_id,
                summary                => :summary,
                description            => :description,
                description_format     => :description_format,
                content                => :content,
                generated_from_version => :version_id,
                creation_user          => :user_id,
                creation_ip            => :ip_address
            );
        end;
  </querytext>
</fullquery>

</queryset>