Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Specify the number of rows in Cursor

Former Member
0 Kudos

Hi,

Can anyone tell me, if there is some way where i can specify the number of rows to be fetched in a single cursor.

As in, The first fetch 100 rows, second 100 and so on

Regards,

Rishav

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi

Use the option PACKAGE

FETCH NEXT CURSOR <CURSOR> INTO TABLE <int table> PACKAGE SIZE 100.

Max

2 REPLIES 2

Former Member
0 Kudos

Hi

Use the option PACKAGE

FETCH NEXT CURSOR <CURSOR> INTO TABLE <int table> PACKAGE SIZE 100.

Max

kesavadas_thekkillath
Active Contributor
0 Kudos