ora-01002 out of sequence when running report (business object)

Hi all,

I have the db link from Oracle to sqlserver using ODBC. When we run Business object query from Oracle, it worked fine. When we run the query from Business Object via SQL server, it worked fine but when when run report to Oracle and from ORacle to Sqlserver to get the data, we got the errors ORA-01002 out of sequence. I did some research in Metalink and it said to set prefetch count =0 but that doesn't make sense b/c when Oracle bridge over sqlserver using SQLserver driver and there is no such thing where I can the prefetch count. Does anyone have any advises????

thanks,

review if you have a cursor and verify if have end loop condition.

I know with a transparent gateway from Oracle-> DB2 you couldn't use cursors on remote databases for this reason.