Power Platform Community Forum Thread Details

I am trying to call Oracle dw stored procedure by "Execute Sql statement" in Power Automate Desktop.

The procedure is doing an update to some columns and as a result it should return true or false value whether an update was successful or not. Output parameter should be defined as result set right? I know that previously in Softomotive ProcessRobot output parameter had to be defined as result set.

The procedure is tested through AQT app and it's working, but when I try to call it through robot it doesn't work.

Here is the line in Execute SQL statement which I use to call the procedure: first four parameters are input parameters and question mark is for the output parameter

{call DDW_APL.P_CANCEL_LETTER_RPA_STATUS ('1234567899', null, '2', '2021-05-31', ?)}

Here is the procedure:

OPEN l_result FOR SELECT 'TRUE' FROM DUAL;
ELSE
OPEN l_result FOR SELECT 'FALSE' FROM DUAL;
END IF;

END;

Please help on this.

Kind regards,

Krešimir

Categories:

Power Automate Desktop