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)

Source code:

    set_user_pref__arg_parser

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

<?xml version="1.0"?> <queryset> <fullquery name="preference::get_preference_type_id.select_preference_type_id"> <querytext> select preference_type_id from user_preference_types where short_name= :preference_type </querytext> </fullquery> </queryset>

Postgresql XQL file:

<?xml version="1.0"?> <queryset> <rdbms><type>postgresql</type><version>7.1</version></rdbms> <fullquery name="preference::set_package_default.set_package_default"> <querytext> select user_pref_type__set_package_default( :preference_type_id, :package_id, :default_value ); </querytext> </fullquery> <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> <fullquery name="preference::get_user_pref.get_user_pref"> <querytext> select user_pref_type__get_user_pref ( :preference_type, :package_id, :user_id ); </querytext> </fullquery> </queryset>

Oracle XQL file:

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