This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am using an Excel worksheet as input to get detailed information from a database for each cell. Using the Dynamic input tool I set the character limit to 12000 based on each cell containing 10+(comma+string quote) characters. This worked fine till the 1000 limit encountered where some cells could have less than 10 characters and some cells could have over 10 characters.
" Error: ORA-01795: maximum number of expressions in a list is 1000".
The data is accessed using a read id and cannot insert into a table and then use in IN Statement.
(Select * from table_info where key in (select key from list_table) -->unlimited
(Select * from table_info where key in ('ABCDEFGHIJ','ABCDEFGHIJKL','ABC',..........) -->String limitation and then Ora-01795.
The limit should be based on the Database limitation and not on number of string characters and the tool should be smart enough to build the In Statement based on the connection established. Please fix.