set_row_default procedure

Related topics

Contained in package wwa_api_module_session.

Call this procedure to set the default value of all attributes in a row. The default value of an attribute can be set at design time. If no default value is specified at design time, the attributes are initialized to null.

member procedure set_row_default
(
p_block_name in varchar2,
p_index in integer default 1,
p_language in varchar2
),

Version: Oracle Portal 3.0.9

Parameters:

p_block_name

The name of the block that owns 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

Exceptions:

None.

Example 1:

Consider an Oracle Portal form component based on the SCOTT.EMP table (module_id=7). To set the default value for the row in the DEFAULT block:

Note: For form components based on a table/view just a single row is available at a time.

declare
    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_session.set_row_default (
            p_block_name => 'DEFAULT',
            p_language => <portal_schema>.wwctx_api.get_nls_language
        );
end;
Example 2:
Consider an Oracle Portal master-detail form component. To set the default value of the 3rd row only (detail section):
declare
    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_session.set_row_default (
            p_block_name => 'DETAIL_BLOCK',
            p_index => 3,
            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_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
Exceptions: None. Example 1: Consider an Oracle Portal form component based on the SCOTT.EMP table (module_id=7). To set the default value for the row in the DEFAULT block: Note: For form components based on a table/view just a single row is available at a time. declare 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_session.set_row_default ( p_block_name => 'DEFAULT', p_language => <portal_schema>.wwctx_api.get_nls_language ); end; Example 2: Consider an Oracle Portal master-detail form component. To set the default value of the 3rd row only (detail section): declare 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_session.set_row_default ( p_block_name => 'DETAIL_BLOCK', p_index => 3, p_language => <portal_schema>.wwctx_api.get_nls_language ); end;

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