| 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;

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

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