get_value_as_number function

Related topics

Contained in package wwa_api_module_session.

Call this function to get the (date) value of an attribute, i.e. without any format masks applied on the values.

This function retrieves values set via the set_value procedure.

member function get_value_as_number
(
p_block_name in varchar2,
p_attribute_name in varchar2,
p_index in integer default 1
)
return number,

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

Return:

This function returns a date.

Exceptions:

If the attribute's type indicates that the implementation type is not a DATE column, exception VALUE_ERROR is raised.

Example 1

To retrieve the value of the EMPNO attribute for a form component based on a table, i.e. the A_EMPNO attribute of the session data that was set using the set_value procedure:

declare
    l_empno integer;
    l_session wwa_api_module_session;
begin
        l_session := <portal_schema>.wwa_api_module_session.create_session (
                    p_module_id => 7,
                    p_version => 1
                       );
        l_empno := l_session.get_value_as_number(
                               p_block_name => 'DEFAULT',
                               p_attribute_name => 'A_EMPNO');
end;
Example 2
To retrieve the values of 2 instances of the EMPNO attribute for a master-detail form component, .e. the A_EMPNO attribute of the session data that was set using the set_value procedure.
declare
    l_empno1 integer;
    l_empno2 integer;
    l_session wwa_api_module_session;
begin
        l_session := <portal_schema>.wwa_api_module_session.create_session (
                 p_module_id => 9,
                  p_version => 1
                );
        l_empno1 := l_session.get_value_as_number(
                               p_block_name => 'DETAIL_BLOCK',
                               p_attribute_name => 'A_EMPNO',
                               p_index => 1);
        l_empno2 := l_session.get_value_as_number(
                               p_block_name => 'DETAIL_BLOCK',
                               p_attribute_name => 'A_EMPNO',
                               p_index => 2);
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
Return: This function returns a date. Exceptions: If the attribute's type indicates that the implementation type is not a DATE column, exception VALUE_ERROR is raised. Example 1 To retrieve the value of the EMPNO attribute for a form component based on a table, i.e. the A_EMPNO attribute of the session data that was set using the set_value procedure: declare l_empno integer; l_session wwa_api_module_session; begin l_session := <portal_schema>.wwa_api_module_session.create_session ( p_module_id => 7, p_version => 1 ); l_empno := l_session.get_value_as_number( p_block_name => 'DEFAULT', p_attribute_name => 'A_EMPNO'); end; Example 2 To retrieve the values of 2 instances of the EMPNO attribute for a master-detail form component, .e. the A_EMPNO attribute of the session data that was set using the set_value procedure. declare l_empno1 integer; l_empno2 integer; l_session wwa_api_module_session; begin l_session := <portal_schema>.wwa_api_module_session.create_session ( p_module_id => 9, p_version => 1 ); l_empno1 := l_session.get_value_as_number( p_block_name => 'DETAIL_BLOCK', p_attribute_name => 'A_EMPNO', p_index => 1); l_empno2 := l_session.get_value_as_number( p_block_name => 'DETAIL_BLOCK', p_attribute_name => 'A_EMPNO', p_index => 2); end;

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