Hi,
I am trying to execute a query and I am getting a white space/ blank as the output. This query is giving me a correct output when I run it in Oracle SQL Developer.
Is it because the way the query is structured? The query start with a “With” statement.
Can anyone help me with this?
Hi @Shruti_Fanse, Welcome to Uipath community,
Before executing a query , we must first connect to the database using the Connect activity. This activity requests a connection string used to establish a database connection and a ProviderName. The string must contain a data source, a user name and a password.
Based on your screenshot, I couldnt find “Connect” activity , So Use connect activity and let me know your results.
Hi @vinodhvictor94,
Thank you for your suggestion. I did not use the connect activity but I just added the connection string in the Execute Query activity. The connection was successful and I am getting the output when I am using another query. So I thought maybe the issue was with the way the query is structured?
@Shruti_Fanse Is it possible for you to upload the Xaml file to have a better look
Unfortunately I cannot load the file as it it work related.
I changed the way I was creating the DSN and the query is working now.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
