AnsweredAssumed Answered

Calling PL/SQL code snippets using Boomi shapes?

Question asked by iamshinde on Aug 7, 2018
Latest reply on Aug 7, 2018 by Sjaak Overgaauw

Hi All,


Is it possible to call below pl/sql statement using Boomi shapes?

Note : we can not use Program Command shape, just because it won't return any output of provided code.





v_account_num NUMBER := '522751';
var_dtl_tab adm.abc_pkg.dtl_tab := adm.abc_pkg.dtl_tab();                           -- RowType 
b VARCHAR2(500) := NULL;



adm.mgmt_intf_pkg.get_delr_details(v_account_num, var_dtl_tab);        -- Stored procedure call
b := 'Value at ' || 1 || ' IS ==>' || var_dtl_tab(1).dler_name;




note : I want 'b' as an out parameter.



FYI, We have tried the above snippets of code in Map using SqlLookup, but no luck, statement is executing but we are getting null output.    but the same code is working in SQL-Developer



Many Thanks in advance,