4.3.4 Executing the SYNCHRONIZE_INSTRUMENT

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 Schema Owner.
2. The procedure requires 2 parameters - table name to be synchronized and the As of Date.
3. Identify the table name parameter by enclosing it in single quotes and uppercase, as shown in the following two examples. The syntax for calling the procedure is:
   Declare output number;Begin synchronize_instrument('Batch_Id', 'TABLE_NAME', output)End;
   where
   table_name is either:
   The name of an Instrument table
   LEDGER_STAT
   An example of running the stored procedure from SQL*Plus for the FSI_D_TERM_DEPOSITS table follows:
   SQL> var output number;SQL> synchronize_instrument('INFODOM_20101231','FSI_D_TERM_DEPOSITS',:output);
4. To execute the stored procedure from within a PL/SQL block or procedure, see the example that follows. Call the procedure as often as required to synchronize all of your instrument tables. The appropriate table name and AS_OF_DATE is enclosed in single quotes.
   SQL> declare output number; begin synchronize_instrument('INFODOM_20101231','LEDGER_STAT',output); end; /
5. 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: fn_Synchronize_Instrmts
   Parameter List: Instrument Table Name or LEDGER_STAT