notification-request-procs-oracle.xql

DB Query file

Related Files

• packages/notifications/tcl/notification-request-procs.xql
• packages/notifications/tcl/notification-request-procs.tcl
• packages/notifications/tcl/notification-request-procs-postgresql.xql
• packages/notifications/tcl/notification-request-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="notification::request::delete.delete_request">
        <querytext>
            declare begin
                notification_request.del(request_id => :request_id);
            end;
        </querytext>
    </fullquery>

    <fullquery name="notification::request::delete_all.delete_all_requests">
        <querytext>
            declare begin
                notification_request.delete_all(object_id => :object_id);
            end;
        </querytext>
    </fullquery>

    <fullquery name="notification::request::delete_all_for_user.delete_all_for_user">
        <querytext>
            declare begin
                notification_request.delete_all_for_user(user_id => :user_id);
            end;
        </querytext>
    </fullquery>

</queryset>