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

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.script_delete

Remove a BPEL process
BPEL.BPEL.script_delete (in script varchar, in delete_instances int);
Parameters
script – int the identifier of the BPEL process to be deleted
delete_instances – int this flag specifies to delete all instances of the given process
Return Types

this function has no return value

Description

BPEL.BPEL.script_delete Deletes all versions of the BPEL process and all related partner links, instances, sources etc. if delete_instances is false and there exist instances of at least one version of the script the function signals an error and does nothing

Examples
Simple example

The following will delete script with ID equal of 3 and all it's instances

    	  SQL> BPEL.BPEL.script_delete (5, 1);
              Done. -- 10 msec.