5.20.2 Executing the Gap Limit loader

There are two ways to execute the Gap Limit Loader procedure: Running Procedure Using SQL*Plus and Gap Limit Loader Procedure Using OFSAAI Batch Maintenance

1. To run the function from SQL*Plus, log in to SQL*Plus as the Schema Owner.
   The loader requires two parameters:

   • Batch Execution Name
   • As Of Date
   Syntax:
   fn_load_fsi_alm_gap_limits (batch_run_id IN VARCHAR2, as_of_date IN VARCHAR2)
   For example:
   SQLPLUS > declare
   result number;beginresult := fn_load_fsi_alm_gap_limits (‘INFODOM_20100405','20100405’);
   end;
   /
2. To execute Gap Limit Loader from OFSAAI Batch Maintenance, a seeded Batch <INFODOM>_GAP_LIMITS_LOADER is provided.
   The batch parameters are:

   • Datastore Type: Select the appropriate datastore from list.
   • Datastore Name: Select the appropriate name from the list.
   • IP address: Select the IP address from the list.
   • Rule Name: fn_load_fsi_alm_gap_limits
   • Parameter List: None