oracle8.1.6 declare begin user_pref_type.set_package_default( preference_type_id => :preference_type_id, package_id => :package_id, default_value => :default_value ); end; 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; declare begin :1 := user_pref_type.get_user_pref ( preference_type_id => :preference_type_id, package_id => :package_id, user_id => :user_id ); end;