get_value_as_string function

Related topics

Contained in package wwa_api_module_session.

Call this function to get the value of an attribute as a type-specific NLS formatted string, i.e. to retrieve the value when a format mask is specified at design time.

member function get_value_as_string
(
p_block_name in varchar2,
p_attribute_name in varchar2,
p_index in integer default 1
p_language in varchar2
)
return varchar2,

Version: Oracle Portal 3.0.9

Parameters:

p_block_name

The name of the block that owns the attribute.

Datatype: varchar2

p_attribute_name

The name of the attribute.

Datatype: varchar2

p_index

The index of the value, for n-valued attributes.

Datatype: integer

Default: 1

p_language

The language to be used for all value transformations.

Datatype: varchar2

Return:

This function returns a text string version of the attribute value, transformed according to a set of rules defined against the attribute's type.

Exceptions:

None.

Example:

Consider an Oracle Portal form component based on the SCOTT.EMP table (module_id=7). The HIREDATE attribute has the format mask fmdd-mm-yyyy hh24:mi:ss.

To retrieve the value of the A_HIREDATE session data attribute, set using the set_value_as_string procedure:

declare
    l_session wwa_api_module_session;
    l_value varchar2(4000);
begin
        l_session := <portal_schema>.wwa_api_module_session.create_session (
                   p_module_id => 7,
                   p_version => 1
                       );
        l_value:= l_session.get_value_as_string(
               p_block_name => 'DEFAULT',
               p_attribute_name => 'A_HIREDATE',
               p_language => <portal_schema>.wwctx_api.get_nls_language
        );
end;

Version: Oracle Portal 3.0.9
Parameters:
p_block_name	The name of the block that owns the attribute. Datatype: varchar2
p_attribute_name	The name of the attribute. Datatype: varchar2
p_index	The index of the value, for n-valued attributes. Datatype: integer Default: 1
p_language	The language to be used for all value transformations. Datatype: varchar2
Return: This function returns a text string version of the attribute value, transformed according to a set of rules defined against the attribute's type. Exceptions: None. Example: Consider an Oracle Portal form component based on the SCOTT.EMP table (module_id=7). The HIREDATE attribute has the format mask fmdd-mm-yyyy hh24:mi:ss. To retrieve the value of the A_HIREDATE session data attribute, set using the set_value_as_string procedure: declare l_session wwa_api_module_session; l_value varchar2(4000); begin l_session := <portal_schema>.wwa_api_module_session.create_session ( p_module_id => 7, p_version => 1 ); l_value:= l_session.get_value_as_string( p_block_name => 'DEFAULT', p_attribute_name => 'A_HIREDATE', p_language => <portal_schema>.wwctx_api.get_nls_language ); end;

Related topics
Form component session API package	PDK PL/SQL API Reference - Home