How to split and load records

Posted by Oswaldlily under C# on 5/2/2016 | Points: 10 | Views : 241 | Status : [Member] | Replies : 1
{System.Data.OracleClient.OracleException: ORA-01795: maximum number of expressions in a list is 1000


string[] list_key = {1,2,3,.................................... 10000}
string split = "'" + string.Join("','", list_key) + "'";

Oracle query - select * from Tablename where column1 in (" + split+ ")";

When I run the query which has 10000 in alist, giving out the error mentioned.

How to split into 500 and select itthen have to load into Datatable




Responses

Posted by: Rajnilari2015 on: 5/3/2016 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 25

Up
0
Down
You can then join by 100 records and use.....

--
Thanks & Regards,
RNA Team

Oswaldlily, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response