3.7.4 Executing the Validation Procedure

You can execute this procedure either from SQL*Plus or from within a PL/SQL block or from Batch Maintenance window within OFSAAI framework.

1. To run the procedure from SQL*Plus, login to SQL*Plus as the Atomic Schema Owner. The syntax for calling the procedure is:
   set serveroutput off Declare Output number; Begin Output := fsi_batchtableclassreq(pbatchid, pmis_date); End;

   Note:

   Since the package contains huge number of dbms_output statements, user should either increase the output buffer size or disable the server output.
   For Example:
   set serveroutput off Declare Output number; Begin Output := fsi_batchtableclassreq('INFODOM_INSTRUMENT_TABLE_VALIDATION_20131205_1', '20131205'); End;
2. To execute the procedure from OFSAAI Batch Maintenance, create a new Batch with the Task as TRANSFORM DATA and specify the following parameters for the task:
   Datastore Type: Select appropriate datastore from list
   Datastore Name: Select appropriate name from the list
   IP address: Select the IP address from the list
   Rule Name: Batch_Table_Class_Req
   Parameter List: Batch Identifier and MISDATE