Execute a large PL/SQL query using UiPath

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?

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

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

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

seems to be issue with inserting data into the table

check this please
http://www.dba-oracle.com/t_ora_00922_missing_or_invalid_option.htm

Regards,
Nived N

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