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

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

gets BPEL variable data within <bpelv:exec binding="SQL"> activity
BPEL.BPEL.getVariableData (in var_name varchar, in part varchar, in query varchar);
Parameters
var_name – varchar the name of BPEL variable
part – varchar default null the part of BPEL variable in question.
query – varchar default null XPATH query for selecting data in the BPEL variable
Return Types

this function returns the selected data from the BPEL variable. This can be either an XML tree or a varchar or an integer.

Description

BPEL.BPEL.getVariableData

Returns select by query exression data from part (if applicable) of the BPEL variable. If the variable is unknown, or if the XPATH expression signals an error, the appropriate error is signaled.

This procedure may only be used in Virtuoso/PL code invoked from a BPEL process.

Examples
Simple example

    declare city, country varchar;
    city := cast (BPEL.BPEL.getVariableData ('request',
    		'req_payload',
    		'/destRequest/city/text()');