Prev Up Next
BPEL.BPEL.instance_delete Home BPEL.BPEL.script_delete

Name

BPEL.BPEL.purge_instance — removes old BPEL process instances

Synopsis

BPEL.BPEL.purge_instance ( in completed_before datetime ,
in make_archive int (default 1) );

Parameters

completed_before

datetime all instances completed before this date and time will be removed

make_archive

int flag to archive or not instances before removal

Return Types

Description

BPEL.BPEL.purge_instance this will erase all instances completed before the datetime specified.

Examples

Example24.642.Simple example

The following wil lremove all process instances completed before 10 of January 2004.

          SQL> BPEL.BPEL.purge_instance (stringdate ('2004-01-10'));
          Done. -- 10 msec.

Prev Up Next
BPEL.BPEL.instance_delete Home BPEL.BPEL.script_delete