preference-procs-oracle.xql

DB Query file

Related Files

• packages/user-preferences/tcl/preference-procs.xql
• packages/user-preferences/tcl/preference-procs.tcl
• packages/user-preferences/tcl/preference-procs-postgresql.xql
• packages/user-preferences/tcl/preference-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="preference::set_package_default.set_package_default">
<querytext>
declare begin
  user_pref_type.set_package_default(
       preference_type_id => :preference_type_id,
       package_id => :package_id,
       default_value => :default_value
  );
end;
</querytext>
</fullquery>

<fullquery name="preference::set_user_pref.set_user_pref">
<querytext>
declare begin
   user_pref_type.set_user_pref(
        preference_type_id => :preference_type_id,
        package_id => :package_id,
        user_id => :user_id,
        value => :value
   );
end;
</querytext>
</fullquery>

<fullquery name="preference::get_user_pref.get_user_pref">
<querytext>
declare begin
:1 := user_pref_type.get_user_pref (
           preference_type_id => :preference_type_id,
           package_id => :package_id,
           user_id => :user_id
      );
end;
</querytext>
</fullquery>
 
</queryset>