Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid set of rows requested,... reset pagination

194518May 2 2007 — edited May 3 2007
Hi,

I get an "Invalid set of rows requested, the source data of the report has been modified reset pagination" error every now and then.

I have an application with a report (sql Query) in Page 1. This is a one column report which is a hyperlink (Column Link) to page 2. It passes two values(X1, X2) to Page 2. On page 2 I have a "Branch To Function Returning Page " in "Before Header" that looks into values of X1 and X2 and branches one of the several Pages (3 to 8).

All the pages (3 to 8) have reports based on SQL Query. Page 3 is a one column report, Page 4 is a two column report, Page 5 is a three column report and so on.

I get this error message when I try to access one of these pages (3 to 8). It happens randomly. If I click on the reset pagination link after the error message, then the page gets displayed properly. What is causing this? Any help is appreciated. Thanks in advance.

raje.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 31 2007
Added on May 2 2007
4 comments
939 views