Oracle9iAS Portal Developer Kit

set_attribute_as_string member procedure

Contained in package wwsto_api_session.

Call this procedure to set the value of the attribute given a type-specific, NLS formatted text string.

The text string is transformed (internally) into the native form by calling upon the attribute's type handling object. The native form is then stored.

Note: The attribute type may have performed extensive transformation on the text string before returning it as a native type.

member procedure set_attribute_as_string

(

p_name in varchar2,

p_value in varchar2,

p_language in varchar2,

p_type_name in varchar2 default 'STRING'

);

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_name

The name of the attribute.

Datatype: in varchar2

p_value

The string value to be set.

Datatype: in varchar2

p_language

The language that should be used for all value transformations.

Datatype: in varchar2

p_type_name

The name of the datatype.

Datatype: in varchar2
Default: 'STRING'

Exceptions:

If the value passed in p_value parameter cannot be transformed to the data type specified in p_type_name then VALUE_ERROR exception is raised and the corresponding error, i.e. an invalid datatype name was passed, is added to the error stack.

Example:

It is recommended that the provider implementation does not exist in the same schema as Oracle Portal. Therefore, calls to wwsto_api_session methods must be prefixed by the Oracle Portal owner schema, for example, PORTAL30.

declare
l_user_obj portal30.wwsto_api_session;
begin
l_user_obj := portal30.wwsto_api_session.load_session
 (

p_domain => 'PORTAL',
p_sub_domain => 'TEST'

 );

l_user_obj.set_attribute_as_string
  (

p_name => 'BGCOLOR',
p_value => 23,
p_language => wwnls_api.AMERICAN

 );

l_user_obj.save_session;

Related topics

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