Sybernet / Supplied Procedures Reference Release 3.00 Oct 14, 2002

HTTP.SP_DELPREFERENCE

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 delete a preference that was assigned when you called sp_putPreference.

Syntax

Procedure SP_DELPREFERENCE
(
    NAME                          VARCHAR2
)   ;

Parameters

name

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