HOW TO GET ORACLE PL/SQL values OUT OF A MACHINE STEP

Hi. If I am using an Oracle connector, how do I get values out of the machine step? I vaguely recall doing this years ago but lost the backup of the code.

For example, let’s say I have an Oracle machine step and I want to run an anonymous block of SQL and return a value or two for use in the next step in my flow, remind me how to do that, please.

Try

:Out_YourParameter := YourSQLVariable;

Once you do that a record (w/o iterator) or a Table (with iterator) should activate as output on the top right.

3 Likes

Here is another example with an api call…

DECLARE
v_barcode VARCHAR2(200) := :vBarcode;
v_01_gtin_result VARCHAR2(200) := NULL;
v_10_lot_result VARCHAR2(200) := NULL;
v_17_exp_result VARCHAR2(200) := NULL;
v_21_serial_result VARCHAR2(200) := NULL;
v_37_result VARCHAR2(200) := NULL;
v_decoded VARCHAR2(2000) := NULL;
v_verified VARCHAR2(2000) := NULL;
BEGIN
ifsapp.vns_barcode_decode_api.Get_gs1_readable(i_barcode => v_barcode, o_01_gtin_result => v_01_gtin_result, o_10_lot_result => v_10_lot_result, o_17_exp_result => v_17_exp_result, o_21_serial_result => v_21_serial_result, o_37_result => v_37_result, o_decoded => v_decoded, o_verified => v_verified);

:out_gtin := v_01_gtin_result;

:out_lot := v_10_lot_result;

:out_exp := v_17_exp_result;

:out_serial := Nvl(v_21_serial_result, '*');

:out_id37 := v_37_result;

:out_decoded := v_decoded;

:out_verified := v_verified;

END;

In the Flow Object…