Name

BPEL.BPEL.getVariableData — gets BPEL variable data within <bpelv:exec binding="SQL"> activity

Synopsis

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

Example24.648.Simple example

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