Skip to Main Content
Forums

SQL & PL/SQL

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!

Problem in fetch limit

488411Jan 23 2009 — edited Jan 23 2009
Hi all,

I am facing a problem while fetching the data using cursor.

I have used fetch limit option.

Say for example, a recordset count identified by the cursor is 250 and if i am giving the fetch limit as 500. It is not getting me any result. But if i give the fetch limit as 150, i am getting the expected output.
The problem is i cannot predict what would be my recordset count.

Please help me in this regard.

Regards,
Swami
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2009
Added on Jan 23 2009
10 comments
588 views