passing variable to sql when variable values >1000
i have specific requirement to connect to multiple database where my first database gives me actual data and from this data i need to take a columns values and pass it on to my second database and check if these records are present.
US DB INDIA DB
ABC1 need to check if ABC1 ,ABC2, ABC3, ABC4 are present in this database
i was able to do a peek and get the values in to a temp variable
Now the problem is if the values are more than 1000 oracle database doesn't allow me to pass it in "Where " clause .
i need to parse the strings upto 999 and then loop it accordingly for the rest
we can do a query on the second(Indian DB), But the result will be too huge and time taken for the retrieval is also very high. So still thinking any other alternatives or easier way to limit the variable to 999 and pass it to the second DB