I make queries to several databases in the same SQL, using union, to indicate each oracle database in each query I use @ database1, @ database2, …
This is possible to do in uipath?
Or do I have to do each query independently and then join them together?
Thank you very much for the info, I have previously carried out other processes as you say, but I wanted to try to do everything in a single query.
The problem as you comment is the multiple connections, that is why I have tried to pass it as a parameter, however it does not work for me.
Thanks for the help, I leave the topic open in case someone comes up with the solution.
All the best