Sybernet / Supplied Procedures Reference
Release 3.00
Oct 14, 2002

HTTP.SP_GETPREFERENCE

This is one of three procedures for maintaining user preferences in Sybernet. Its primary purpose is to save user preferences for building the HTML body tag using SP_HTML_PREFERENCES. You can also use these procedures to temporarily (or permanently) store variables that may be shared between processes. These temporary variables, however, are user specific and persist until explicitly deleted with sp_delPreference. Two users logged into the same schema name share the same preference.

This procedure is used to retrieve a preference that was assigned when you called sp_putPreference.

Syntax

Procedure SP_GETPREFERENCE
(
    NAME                          VARCHAR2
,   VALUE               OUTPUT    VARCHAR2
,   PREFERENCE                    VARCHAR2
)   ;

Parameters

Parameter	Description
name	The case-sensitive user preference that is to be retrieved.
value	The value corresponding to this preference.
preference	The value to return if no preference is defined.

Example 1

The following example illustrates how to create a user preference:

http.sp_putPreference('FavoriteFood','Lasagne');

Example 2

The following example illustrates how to retrieve a user preference:

declare
    favoriteFood varchar(255);
begin
    http.sp_getPreference('FavoriteFood',FavoriteFood,'Pizza');
    http.writeln('Your favorite food is ' || FavoriteFood);
end;

Example 3

The following example illustrates how to delete a user preference: