Re: ORA 1002 - fetch out of sequence problem in reports 2.5

>rtproffitt_at_my-deja.com wrote:
>

<snip>
>>
>> Summary:
>> The cursor is no longer valid.
>>
>> Common Causes:
>> Fetching after cursor returns no data.
>> Example: an infinite loop with no exit:
>> Open c1;
>> loop fetch c1 into x; End Loop;
>>
>> Second Case:
>> Selecting for Update, and while in the loop updating with a COMMIT.
>> "commit across fetches in a select for update "
>> The document explains the locking strategy and why this causes
>> the error.
>> "The solution to this problem is to move the commit
>> outside the fetch loop or use a simple select rather
>> than a select for update."
>>
>> Robert Proffitt
>> Beckman Coulter

I knew this - my problem is that there is no infinite loop, and this is not a select for update. The query is the master query in a report. The returned data is just used to populate the report. To make matters worse, this only happens with one specific set of query parameters.

It's probably insoluable. I just will have to get their 6000 records out, in a readable form, using SQL prob - at least that gives me bloody sensible error messages.

Thanks for the help though

Jo
>

The usual - anything I say reflects on me, and not upon my current employer.