Execute Oracle Stored Procedures

Help
1

Hi All,

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

image

image
image849×318 17.8 KB

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

1 Like
2

Buddy try to implement the common syntax of oracle to execute a query
like this
“EXECUTE Schemaname.ProcedureName(‘argument’);”

For more info on using syntax

https://docs.oracle.com/cd/B28359_01/olap.111/b28126/dml_app_dbms_aw026.htm#OLADM984

Try with this and let know buddy
Cheers @pandey61ankit

1 Like
3

I have connected UiPath.Database.Activities -1.7.1 to oracl database and want to connect StoreProcedures to Run query but Keep getting Error -