Oracle9iAS Portal Developer Kit

set_context procedure

Contained in package wwctx_api.

Call this procedure to set the context for the current browser session. This function creates a session row in the Oracle Portal global context sub-system, and sets the following values for the appropriate columns:

  • USER_NAME ( p_user_name)

  • DB_USER (user currently logged in)

  • NLS_LANGUAGE (default language)

  • IP_ADDRESS (null)

  • LOGIN_TIME (sysdate)

Notes:

  • The set_context call allows a non-browser-based client to set the session context which normally would be set by a browser session.

  • Since this context setting asserts identity, which is normally authenticated through a browser login, a user_name and password are required in this call to perform the authentication.

procedure set_context

(

p_user_name in varchar2,

p_password in varchar2 default null,

p_company in varchar2 default null

);

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_user_name

The user's login name.

Datatype: in varchar2

p_password

The user's Single Sign-On (SSO) password.

Datatype: in varchar2
Default: null

p_company

The name of the company associated with this user.

Note: This field is available in Oracle9iAS Portal 9.0.2 or later.

Datatype: in varchar2
Default: null

Exceptions:

If the user name or password is not valid, an AUTHENTICATION_EXCEPTION is raised.

Example:

wwctx_api.set_context

(

p_user_name => 'SCOTT',

p_password => 'TIGER',

p_company => 'Oracle'

);

Related topics

The PL/SQL API Reference is part of the Portal Developer Kit on Portal Studio