Sybernet / Supplied Procedures Reference Release 3.00 Oct 14, 2002

HTTP.SP_PUTPREFERENCE

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 create a user preference.

Syntax

Procedure SP_PUTPREFERENCE
(
    NAME                          VARCHAR2
,   VALUE                         VARCHAR2
)   ;

Parameters

name

value

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:

http.sp_delPreference('FavoriteFood');

See Also