ORA-01002 fetch out of sequence 1

[Kebabmeister]

We have just 'upgraded' to CR V9 (Yes I know) running on oracle 9 and one of the V8.5 reports now throws up this error. Copying the query and running it in toad does not throw up the same error so I imagine it is a CR query engine problem.

1) Has anyone ever run into this problem (You may have to think back a bit)?

2) Is there a patch we haven't got (product version 9.2.2.634)?

3) Anyone got any Paracetamol?

 

[smcnulty2000]

What happens when you go to the database menu and run 'Show SQL Query'? In other words, could you post the results?

are you using ODBC, OLE, or Oracle Native driver? Might be worthwhile switching.

 

[Kebabmeister]

Thanks for the suggestion, changing the driver worked.