forum-reply-procs-oracle.xql

DB Query file

Related Files

• packages/forums/tcl/forum-reply-procs.xql
• packages/forums/tcl/forum-reply-procs.tcl
• packages/forums/tcl/forum-reply-procs-postgresql.xql
• packages/forums/tcl/forum-reply-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="forum::notification::get_url.select_forums_package_url">
        <querytext>
            select site_node.url(node_id)
            from site_nodes
            where object_id = (select package_id
                               from forums_forums
                               where forums_forums.forum_id = :forum_id)
        </querytext>
    </fullquery>

 
</queryset>