preference::set_user_pref (public)

 preference::set_user_pref -preference_type preference_type \
    [ -package_id package_id ] -user_id user_id -value value

Defined in packages/user-preferences/tcl/preference-procs.tcl

Set a user preference.

Switches:

-preference_type

(required)

Corresponds to the short_name parameter to preference::type::new

-package_id

(optional)

-user_id

(required)

-value

(required)

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Source code:

        # get the preference type id
        set preference_type_id [get_preference_type_id -preference_type $preference_type]

        # exec the PL/SQL
        db_exec_plsql set_user_pref {}

Generic XQL file:

packages/user-preferences/tcl/preference-procs.xql

PostgreSQL XQL file:

<fullquery name="preference::set_user_pref.set_user_pref">
    <querytext>
select user_pref_type__set_user_pref(
        :preference_type,
        :package_id,
        :user_id,
        :value
);
</querytext>
</fullquery>

packages/user-preferences/tcl/preference-procs-postgresql.xql

Oracle XQL file:

<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>

packages/user-preferences/tcl/preference-procs-oracle.xql