How to execute functions using ADB request/reply from BW ?

How to execute functions using ADB request/reply from BW ?

book

Article ID: KB0085519

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database -
Not Applicable -

Description

Resolution:
ADB support functions in request/reply from ADB v4.2.0 patch2 onwrads.

Following are the steps assuming we are calling the following function :-

> function get_order(id IN number, desc1 OUT varchar2)
> return NUMBER
> is
> begin
>   select order_description into desc1 from order_table
where order_id =
> id;
> return(1);
> end;
>

The syntax for calling the function is :-

{?=call funcName(?,?)}

Where the
first ? is for RETURN value
second ? is for IN parameter
third ? is for OUT par

Issue/Introduction

How to execute functions using ADB request/reply from BW ?

Attachments

How to execute functions using ADB request/reply from BW ? get_app