I am trying to do database dump activity from one environment to another. Initially I am connecting to UAT environment, run the select query and save the result in Datatable. Then connecting to QA environment and using “Insert” database activity to dump data-table results (which is taken from UAT)
When using “Insert” database activity, UIpath will give error saying- “Insert : ORA-00936: missing expression”. How to resolve this error? How in general we can resolve issues found from Insert Query? Because What i am doing is fetching query results to data table and trying to insert the same data-table content in different environment.
Both databases are having the same column names and same data types.
Since column names are more and types are unknown, i do not want to use “Execute non Query” command. Need input on how to dynamically bulk insert Values from data-table.
Any help would be appreciated.