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
Example 24.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.