Execute a large PL/SQL query using UiPath

Help Studio
, , , ,
1

I have a huge oracle sql query having few queries including cursors, select, inserts.
But I am not able to run it using the ExecuteQuery activity in UiPath. Is there any other way to achieve this?

2

Hi @dilii
is it thrwoing any error while running through uipath?

3

Yes, it throws an error as Missing or Invalid options.

4

Hi @dilii
seems to be issue with code (query)

seems to be issue with inserting data into the table

check this please

Regards,
Nived N

5

this query is working fine in SQL developer. but it throws this error when running through UiPath studio.