SQL & PL/SQL

i have a very big doubt about ORA_NUM_PROCESSED_ROWS varible type or its range.
what is its range. upto which value it can store and return the number of rows.

actualy i have the situation like this.

I have define a cursor like this :
EXEC SQL DECLARE dcs_ctngrp CURSOR FOR
SELECT ' ',SUBSTR(SUBSCRIBER_NO,1,7),COUNT(*)
FROM SUBSCRIBER WHERE SUBSCRIBER_NO > ' '
GROUP BY SUBSTR(SUBSCRIBER_NO,1,7);

If i run this query in TOAD , it is returning me 41605 rows..

But i am running this query in my program and fetching the cursor in a variable whose buffer size is 80000.

1) in this case i am getting only 14464 rows as value of ORA_NUM_PROCESSED_ROWS and sqlcode = 0.

2) when i define buffer as 7000, i am getting only 4464 rows as value of ORA_NUM_PROCESSED_ROWS and sqlcode = 0.

3) when i define buffer as 65000, i am getting 41605 rows and sqlcode 100.(which i want, this should also come in abouve situation also)

so, from point 1, 2 i get a clue that ORA_NUM_PROCESSED_ROWS might have range till 65536. after than it again repeat.
like 80000-14464 = 65536
70000-4464 = 65536..


So, could anybody please clearify my doubts why is it happening.

Edited by: user10873676 on 29-Jan-2009 10:29 PM