Installing the Stored Procedure for Oracle

Procedure

  1. Copy the stored procedure file to a temporary location on the server, say C:\temp\ec_delete_audit_stats_data_ora.sql.
  2. Open the SQL*Plus command window and login using the TIBCO ActiveMatrix BPM Runtime Database user (default: bpmuser) credentials.
  3. Execute the command:
    @C:\temp\ec_delete_audit_stats_data_ora.sql