get_value_as_date function

Related topics

Contained in package wwa_api_module_session.

Call this function to get the (date) value of an attribute in the native form, 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_date
(
p_block_name in varchar2,
p_attribute_name in varchar2,
p_index in integer default 1
)
return date,

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 HIREDATE attribute of a form component based on a table, i.e. the A_HIREDATE attribute of the session data set using the set_value procedure :

declare
    l_HIREDATE date;
    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_HIREDATE := l_session.get_value_as_date(
                               p_block_name => 'DEFAULT',
                               p_attribute_name => 'A_HIREDATE');
end;
Example 2:
To retrieve the values of 2 instances of the HIREDATE attribute for a master-detail form component, i.e. the A_HIREDATE attribute of the session data that was set using the set_value procedure:
declare
    l_HIREDATE1 date;
    l_HIREDATE2 date;
    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_HIREDATE1 := l_session.get_value_as_date(
                               p_block_name => 'DETAIL_BLOCK',
                               p_attribute_name => 'A_HIREDATE',
                               p_index => 1);
        l_HIREDATE2 := l_session.get_value_as_date(
                               p_block_name => 'DETAIL_BLOCK',
                               p_attribute_name => 'A_HIREDATE',
                               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 HIREDATE attribute of a form component based on a table, i.e. the A_HIREDATE attribute of the session data set using the set_value procedure : declare l_HIREDATE date; 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_HIREDATE := l_session.get_value_as_date( p_block_name => 'DEFAULT', p_attribute_name => 'A_HIREDATE'); end; Example 2: To retrieve the values of 2 instances of the HIREDATE attribute for a master-detail form component, i.e. the A_HIREDATE attribute of the session data that was set using the set_value procedure: declare l_HIREDATE1 date; l_HIREDATE2 date; 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_HIREDATE1 := l_session.get_value_as_date( p_block_name => 'DETAIL_BLOCK', p_attribute_name => 'A_HIREDATE', p_index => 1); l_HIREDATE2 := l_session.get_value_as_date( p_block_name => 'DETAIL_BLOCK', p_attribute_name => 'A_HIREDATE', p_index => 2); end;

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