Products | Versions |
---|---|
TIBCO ActiveMatrix BusinessWorks Plug-in for Database | - |
Not Applicable | - |
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