How to call/execute Oracle Procedure/Function in UiPath - got Invalid SQL stmt error

Hi,

I am trying to call/execute OracleEBS function (FND_REQUEST.Submit request) in UiPath environment by using "Execute query/NonQuery option. Anyone having ideas how to execute Oracle Function in UiPath?

attached error screenshots for calling/executing oracle procedure in UiPath.

Thanks,
Kartheesan

I was trying to set the Oracle EBS Session properties yesterday. Eventually found out the correct syntax…

Command Type was Text
SQL Was
begin
mo_global.set_policy_context(:p1,:p2);
END

Note the use of : for variables, I think it must be the equivalent of @ in sqlsever

Then set up the parameters in a with a collection as in the screen dump below

Screen dump of the call note it’s UiPath.Database.Activities.ExecuteNonQuery