4.4.4 Executing the Synchronize Stage

You can execute the SYNCHRONIZE_STAGE 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, logon to SQL*Plus as the Schema Owner. The procedure requires two parameters: The table name to be synchronized and As of Date.
2. 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;Beginfsi_sync_stage('Batch_Id','TABLE_NAME', output)End;
   where table_name is the name of an Stage table.
   An example of running the stored procedure from SQL*Plus for theSTG_INVESTMENTS table follows:
   SQL>var output number;SQL>fsi_sync_stage('INFODOM_20101231','STG_INVESTMENTS',:output);
   To execute the stored procedure from within a PL/SQL block or procedure, see the example that follows. To call the procedure as often as required to synchronize all of your stage tables, the appropriate table name and AS_OF_DATE is enclosed in single quotes.
   SQL> declareoutput number;beginfsi_sync_stage('INFODOM_20101231','STG_INVESTMENTS', output);end;/
3. 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 the appropriate datastore type from the list.
   Datastore Name: Select the appropriate datastore name from the list.
   IP address: Select the IP address from the list.
   Rule Name: synchronize_stage
   Parameter List: Stage Table Name