39.7.2 Using SQL* Plus to Execute a Stratification Rule

You can also execute the stratification rule either from SQL*Plus or from within a PL/SQL block OR from ICC Batch UI within the OFSAAI framework.

To Run the procedure from SQL*Plus, login to SQL*Plus as the Schema Owner. The function requires four parameters. Following is the syntax for calling the procedure:

declare
result number;
begin
---- Call the function
result := fn_insert_into_data_strat_tab(batch_id => :batch_id,
mis_date => :mis_date,
stratification_id => :stratification_id,
user_name => :user_name);
end;

• batch_id: any string to identify the executed batch
• mis_date: in the format YYYYMMDD
• stratification_id: numeric system id of stratification rule
• user_name: OFSAA user id of the user executing the function

Example:

declare
result number;
begin
---- Call the function
result := fn_insert_into_data_strat_tab(batch_id => 'abc',
mis_date => '20180601',
stratification_id => 123,
user_name => AUTOUSER);
end;