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
Phrases
RDF data
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 & 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.