Oracle9iAS Portal Developer Kit

get_nls_territory function

Related topics

Contained in package wwctx_api.

Call this function to return the NLS territory used by the current user of the system (as determined by the Single Sign-On (SSO) cookie).

function get_nls_territory

return varchar2;

Version: Oracle9iAS Portal 9.0.2 or later

Returns:

This function returns the NLS territory used by the current Oracle Portal user.

Exceptions:

  • If no session is found, NO_SESSION_EXCEPTION is raised.
  • If the cookie is corrupt, INVALID_COOKIE_EXCEPTION is raised.
  • If the SSO configuration is not correct, SSO_CONFIG_EXCEPTION is raised.
  • If the remote session is missing, NO_REMOTE_SESSION_EXCEPTION is raised.
  • If local node information is missing, NO_LOCAL_NODE_EXCEPTION is raised.

Example:

l_nls_territory varchar2(30);
l_nls_territory := wwctx_api.get_nls_territory;

Related topics

Back to top

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