Error: "ORA-01795: maximum number of expressions in a list is 1000" may occur when querying an in-list with more than 1000 items.
The error is not a Toad error. It is a specific Oracle database error which is duplicated in Oracle's SQL*Plus as well. The problem is the SQL query not the software.
Replace the "in-list" type query with a nested table.