Work on this db

[manoj_verma1 (manoj verma)]

i am trying to connect to db and have passed an variable in that query but i am getting this error
Execute Query working: ORA-01795: maximum number of expressions in a list is 1000

and the data that i getting from from db can be as low 100 to lakhs how to resolve this

[Gokul001 (Gokul Balaji)]

HI @manoj_verma1

What is the query you used?

Regards
Gokul

[nikhil.girish]

Hi @manoj_verma1

please find the below link regarding same thread

What is maximum number of records in query entity records?

@05211740000055 Welcome to our UiPath community. After using Query Entity Records activity and check Total Records value. It will give output as Total number of matching records value count. If it is greater than 1000 then you can use one more Query Entity Records activity and skip first 1000 records as you already retrieved it and also append this output to previous output. [Screenshot_20210914-061038]

[manoj_verma1 (manoj verma)]

@nikhil.girish cannot find this activity

[nikhil.girish]

Hi @manoj_verma1

kindly refer the links

UiPath Database Queries

EXECUTE QUERY ACTIVITY UIPATH | WRITE SELECT QUERY IN UIPATH | UIPATH RPA

thanks