Examples

  • To delete audit entries or statistical data of process instances for template IDs 1, 3, 5, and 7 (= ec_proc_template.id), and have completed, cancelled, or failed before the specified date:
    CALL EC_DELETE_AUDIT_STATS_DATA(('1, 3, 5, 7', '2011-11-01 10:42:01.008’);
  • To delete audit entries of process instances for all templates completed, cancelled, or failed before the specified date:
    CALL EC_DELETE_AUDIT_STATS_DATA((NULL, '2011-11-01 10:42:01.008’);
  • To delete all audit entries of process instances for template IDs 1, 3, 5, and 7 (= ec_proc_template.id):
    CALL EC_DELETE_AUDIT_STATS_DATA(('1, 3, 5, 7');
  • To delete audit entries for all completed, cancelled, or failed process instances:
    CALL EC_DELETE_AUDIT_STATS_DATA();
  • To delete audit entries for all completed, cancelled, and failed process instances with a different commit batch size (for example 150):
    CALL EC_DELETE_AUDIT_STATS_DATA((NULL, NULL, 150);