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
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 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 expression 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 signalled.

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()');