etp-publish-oracle.xql

DB Query file

Related Files

• packages/edit-this-page/www/etp-publish.xql
• packages/edit-this-page/www/etp-publish.tcl
• packages/edit-this-page/www/etp-publish-postgresql.xql
• packages/edit-this-page/www/etp-publish-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="set_publish_date">
<querytext>
update cr_revisions
set publish_date = sysdate
where revision_id = :latest_revision_id
</querytext>
</fullquery>

<fullquery name="set_audit_info">
<querytext>
update acs_objects
set modifying_user = :user_id,
    last_modified = sysdate
where object_id = :latest_revision_id
</querytext>
</fullquery>

</queryset>