1362
Views
0
Helpful
0
Replies
Calling of Oracle PL/SQL Package using Orchestrator
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-18-2020 02:07 AM
Dear Contributors,
we like to call oracle stored procedure using orchestrator.
How to call a stored procedure with out parameter.
procedure sample_proc_with_outval ( p_result out varchar ) is
begin
return "test value";
end;
Question is how to use the p_result variable in further processing.
How to call a stored function which is having an return value
function sample_function
return number
is
l_num number(20);
begin
l_num:=999;
return l_num;
end;
Question here is how to get the result of the stored procedure.
Thank you
Labels:
0 Replies 0
