Hi
I have a dataprovider which queries Oracle. I need to retrieve the data from the data provider based on a column in excel.
I changed the List of Values(by pointing the LOVs to excel) and then inlcuded that in the condition in the data provider.
But I am unable to run the dataprover since there are more than 999 records. I beleive there is a restriction of 999 in Oracle.
Is there a workaround for this.
Any help is much appreciated.
botech (BOB member since 2006-08-10)
Nothing in Business Objects is going to change the Oracle limit of 1000, sorry. The “best” solution is to get the Excel content loaded to an Oracle table, where a join or sub-query is not subject to the In limitation. A query level solution is to break the list into 1000 value “chunks” and OR several together. You can use the utility found here … Create an InList from an Excel spreadsheet to help.
Dwayne Hoffpauir 
(BOB member since 2002-09-19)
Thanks Dwayne.
botech (BOB member since 2006-08-10)