# \#executequery

**URL:** https://forum.uipath.com/tag/executequery/2051.md

[Latest](https://forum.uipath.com/latest.md) · [Categories](https://forum.uipath.com/categories.md) · [Tags](https://forum.uipath.com/tags.md)

---

## [How to check more than one word contains in string](https://forum.uipath.com/t/how-to-check-more-than-one-word-contains-in-string/5747815)

<div class="topic-metadata">

**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\
**Replies:** 7\
**Last updated:** [May 23, 2026, 7:19am UTC](https://forum.uipath.com/t/how-to-check-more-than-one-word-contains-in-string/5747815 "2026-05-23T07:19:23Z")

</div>

Hello, my requirement is we have automated jira tikcets where automation fetches using API and work on it if Jira ticket summary is like below (fetching using API in string variable\_ summary - Please activate the Jira …

---

## [UiPath.Database.Activities SQL Select Fails with unexpected exit code](https://forum.uipath.com/t/uipath-database-activities-sql-select-fails-with-unexpected-exit-code/602729)

<div class="topic-metadata">

**Author:** [@ui\_auto](https://forum.uipath.com/u/ui_auto)\
**Replies:** 3\
**Last updated:** [September 23, 2023, 10:26pm UTC](https://forum.uipath.com/t/uipath-database-activities-sql-select-fails-with-unexpected-exit-code/602729 "2023-09-23T22:26:53Z")

</div>

I have a very simple scenario MySQL Table has 5 rows id → primary key name → non primary Package installed: UiPath.Database.Activities v1.7.1 After establishing the connection, I use Execute Query. SELECT id from T…

---

## [UiPath execute query | Display results instead of messages](https://forum.uipath.com/t/uipath-execute-query-display-results-instead-of-messages/549590)

<div class="topic-metadata">

**Author:** [@Hithashree8](https://forum.uipath.com/u/Hithashree8)\
**Replies:** 2\
**Last updated:** [May 30, 2023, 11:43am UTC](https://forum.uipath.com/t/uipath-execute-query-display-results-instead-of-messages/549590 "2023-05-30T11:43:48Z")

</div>

I need to extract the data from results no matter what the message is, but in UiPath, when I execute query, I am getting the same error as in sql. Try catch for the query didn’t work.

---

## [No time limit for SQL query](https://forum.uipath.com/t/no-time-limit-for-sql-query/505942)

<div class="topic-metadata">

**Author:** [@koolrc812](https://forum.uipath.com/u/koolrc812)\
**Replies:** 9\
**Last updated:** [January 16, 2023, 7:08am UTC](https://forum.uipath.com/t/no-time-limit-for-sql-query/505942 "2023-01-16T07:08:15Z")

</div>

Hi for the below execute query, how to do the set up no limit time until get the sql results. because sometimes it shows timeout. everytime I have to increase the numbers but it still gets timeout. Do I put out…

---

## [Multiple values in SQL for Execute Query to excel](https://forum.uipath.com/t/multiple-values-in-sql-for-execute-query-to-excel/498402)

<div class="topic-metadata">

**Author:** [@koolrc812](https://forum.uipath.com/u/koolrc812)\
**Replies:** 8\
**Last updated:** [December 12, 2022, 4:01pm UTC](https://forum.uipath.com/t/multiple-values-in-sql-for-execute-query-to-excel/498402 "2022-12-12T16:01:00Z")

</div>

Hi I have got a problem with Execute Query activity. sometimes I got more than 1 values to search in SQL and then write in Excel. with 1 value seems it works for me but with more than 1 values, it doesnt work. my excel …

---

## [Date format is throwing error as ORA-01843: not a valid month while using execute query activity](https://forum.uipath.com/t/date-format-is-throwing-error-as-ora-01843-not-a-valid-month-while-using-execute-query-activity/466476)

<div class="topic-metadata">

**Author:** [@Athulya\_S\_Chandran](https://forum.uipath.com/u/Athulya_S_Chandran)\
**Replies:** 4\
**Last updated:** [August 19, 2022, 5:16pm UTC](https://forum.uipath.com/t/date-format-is-throwing-error-as-ora-01843-not-a-valid-month-while-using-execute-query-activity/466476 "2022-08-19T17:16:33Z")

</div>

I need to get a table from database where (date\_column\_name)\<Today. The format of the value in the column date\_column\_name is dd-MM-yy but while the sql query is given as “Select \* From Work Where inputdate\<‘19-08-22’;…

---

## [Error on large output/result of Execute Query Activity](https://forum.uipath.com/t/error-on-large-output-result-of-execute-query-activity/424593)

<div class="topic-metadata">

**Author:** [@NatesMom](https://forum.uipath.com/u/NatesMom)\
**Replies:** 1\
**Last updated:** [May 20, 2022, 7:40pm UTC](https://forum.uipath.com/t/error-on-large-output-result-of-execute-query-activity/424593 "2022-05-20T19:40:21Z")

</div>

Hi All, I am having this issue with a SQL Query that appears when the output is about 20k (80 columns) rows. I am using StudioX. This error ( RemoteException wrapping System.Exception: Job stopped with an unexpected ex…

---

## [Execute Query Stored Procedure Error](https://forum.uipath.com/t/execute-query-stored-procedure-error/409049)

<div class="topic-metadata">

**Author:** [@cyahsi](https://forum.uipath.com/u/cyahsi)\
**Replies:** 4\
**Last updated:** [March 24, 2022, 11:47am UTC](https://forum.uipath.com/t/execute-query-stored-procedure-error/409049 "2022-03-24T11:47:17Z")

</div>

Hello, I want to execute query which is procedure. When I use execute query activity this error occurs; This stored procedures parameters is; And I use this parameters in UiPath like this; Can anyone help fo…

---

## [How to query two database](https://forum.uipath.com/t/how-to-query-two-database/393096)

<div class="topic-metadata">

**Author:** [@MasterOfLogic](https://forum.uipath.com/u/MasterOfLogic)\
**Replies:** 7\
**Last updated:** [January 21, 2022, 5:03pm UTC](https://forum.uipath.com/t/how-to-query-two-database/393096 "2022-01-21T17:03:06Z")

</div>

Hello guys Please I have this script VTable and AccTable are on separate database. Please anyone help with a sample workflow to execute this query in the studio update VTable set ACCOUNT\_NUMBER = (select Distinct AC…

---

## [Execute Non query Not working - Excel AS db](https://forum.uipath.com/t/execute-non-query-not-working-excel-as-db/381263)

<div class="topic-metadata">

**Author:** [@nithya](https://forum.uipath.com/u/nithya)\
**Replies:** 1\
**Last updated:** [December 20, 2021, 9:09am UTC](https://forum.uipath.com/t/execute-non-query-not-working-excel-as-db/381263 "2021-12-20T09:09:11Z")

</div>

Hi All, I am using execute non query (Excel as db) to update excel. It is updating the excel file when file is open, But if the excel file is closed its not getting updated. Connection string -“Provider=Microsoft.ACE.O…

---

## [Execute a large PL/SQL query using UiPath](https://forum.uipath.com/t/execute-a-large-pl-sql-query-using-uipath/339346)

<div class="topic-metadata">

**Author:** [@dilii](https://forum.uipath.com/u/dilii)\
**Replies:** 4\
**Last updated:** [August 23, 2021, 6:28am UTC](https://forum.uipath.com/t/execute-a-large-pl-sql-query-using-uipath/339346 "2021-08-23T06:28:48Z")

</div>

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?
