# 22. Virtuoso Functions Guide - BPEL.BPEL.purge_instance

Chapter Contents | Prev | Next
Keyword Search:
www.openlinksw.com
docs.openlinksw.com
Book Home
Contents
Preface
Virtuoso Functions Guide
Administration
Aggregate Functions
Array Manipulation
BPEL APIs
bpel.bpel.compile_sc...
bpel.bpel.copy_scrip...
bpel.bpel.getvariabl...
bpel.bpel.get_partne...
bpel.bpel.import_scr...
bpel.bpel.instance_d...
bpel.bpel.plink_get_...
bpel.bpel.plink_set_...
bpel.bpel.purge_inst...
bpel.bpel.script_del...
bpel.bpel.script_obs...
bpel.bpel.script_sou...
bpel.bpel.script_upl...
bpel.bpel.setvariabl...
bpel.bpel.wsdl_uploa...
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web Server & Internet
XML
XPATH & XQUERY
Functions Index

## BPEL.BPEL.purge_instance

removes old BPEL process instances
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
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.