Installing the Stored Procedure for Oracle

Procedure

  1. Copy the stored procedure file to a temporary location on the server, for example: /home/amx-pm/temp/ec_delete_non_instance_audit_data_ora.sql
  2. Open the SQL*Plus command window and login with the BPM user credentials.
  3. Execute the command @/home/amx-pm/temp/ec_delete_non_instance_audit_data_ora.sql