I am working on a project where I need to call a ORACLE stored procedure from UiPath which is already deployed in the target database
The procedure should take manager id as an input parameter while execution.
Functionality of this procedure is to push the resulted data into a temporary table.
Once the data is stored I’ll execute select query in next step to fetch this data into a data table for further processing.
Here I am unable to proceed with the first step i.e. execute stored procedure with the error message as below
The same executed through Oracle client TOAD is working fine but not through uipath activities. Please help
NOTE: I have hard coded the manager ID in this example but in future I will pass a variable