Running Oracle Stored Procedures or Functions

Hello. I am unable to get an Oracle stored procedure (actually a function) to run. I have no issue running my SqlServer stored procedures. My other Oracle select or update statements are working fine against the same Oracle database environment using execute query.

Hi @gary.cook

Could you share more details how you are trying to achieve the same in UiPath Studio? Is the question about the Database activity package?

I was trying to use the database activity package to execute an Oracle function using execute nonquery.

I have resolved the problem using an Invoke Code activity with the appropriate OleDb statements.

Thanks

Gary

1 Like