EBIworld.com > EBI/Clarify Tips > Call SQL Procedure from Business Process Script

Call SQL Procedure from Business Process Script

TAGS: EXTOL SQL / EXTOL customization / EXTOL Business Process Script /

EXTOL Business Integrator allows users to call SQL Procedures from Business Process Scripts.

In our example below we show the SQL Action the actual SQL Procedure. We will pass in a single variable and return a resultant code.

EXTOL Business Integrator SQL Procedure Action


The SQL statement below will pass input process_name variable and the output value will be return

EXTOL Business Integrator SQL Procedure statement

In the Business Process below we will call the SQL Action. We will be prompted to input: process_name and the output will be passed to the variable: return.


EXTOL Business Integrator Business Process Task


For more information on EBI 2.6


By: on
load('http://www.extol.com/extolnews.rss'); $feed = array(); foreach ($rss->getElementsByTagName('item') as $node) { $item = array ( 'title' => $node->getElementsByTagName('title')->item(0)->nodeValue, 'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue, 'link' => $node->getElementsByTagName('link')->item(0)->nodeValue, 'date' => $node->getElementsByTagName('pubDate')->item(0)->nodeValue, ); array_push($feed, $item); } $limit = 4; echo ' A free web counter provided by GoStats.