Re: 'ORA-01002: Fetch out of sequence' in Reports 3.0

Thanks for your suggestion. I have read the description of the NONBLOCKSQL parameter and it says that 'NO means that other programs cannot execute while data is being fetched'. In my case, it should allow others to use the data normally for inserts and Updates. Do you have any suggestion on that?

Ratnaji Garapati

Sunder wrote:

> Set the system parameter NONBLOCKSQL to NO and you will be fine.
>
> Sunder
> Ratnaji Garapati wrote in message <3737120E.8D176593_at_supersolution.com>...
> In Multi-query reports where the different queries are linked, the above
> ora-01002 is occuring randomly. The error is always not coming. Even
> when it happens, not happening in the same situation. We were not able
> to repeat in Development site, but happens in Production site.
>
> Any help is greatly appriciated.
>
> Thanks,
> Ratnaji Garapati
Received on Tue May 11 1999 - 21:10:57 CEST