How to execute functions using ADB request/reply from BW ?
Article ID: KB0085519
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 ?
Feedback
Yes
No
Powered by
