5.22.1 Executing the Behaviour Pattern Loader

To execute the Behaviour Pattern Loader, follow these steps:

1. To run the procedure from SQL*Plus, login to SQL*Plus as the Schema Owner:
   SQLPLUS > declare
   result number;
   begin
   result := fn_Behaviour_pattern_loader ('Behaviour_Pattern_20121212_1','20121212');
   end;
   /
   BATCH_RUN_ID is any string to identify the executed batch.
   AS_OF_DATE is in the format YYYYMMDD
2. To execute Behaviour Pattern Loader from OFSAAI Batch Maintenance, a seeded Batch 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_behaviourpattern