Oracle9iAS Portal Developer Kit

db_to_http_territory function

Contained in package wwnls_api.

Call this function to determine the HTTP territory corresponding to a given database territory.

function db_to_http_territory

(

p_db_territory varchar2

)

return varchar2;

Version: Oracle9iAS Portal 9.0.2 or later

Parameters:

p_db_territory

A territory in database format.

Datatype: varchar2

Returns:

This function returns an HTTP territory code.

Exceptions:

This function raises no user-defined exceptions.

Example:

l_http_territory varchar2(10);

l_http_territory := wwnls_api.db_to_http_territory(

p_db_territory => 'CANADA'

);
-- returns 'ca'

Related topics

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