Output is a Blank when executing a query


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.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.