High volume of records :jdbc stored procedure

Have a receiver stored procedure which populates a table and sender sync proxy scenario. While pulling records from database , is there any limit on how many records can jdbc adapter via stored procedure pull from a table, i would be having about 1000 records to be pulled from a table .

if anybody has any idea about volumes do suggest.

Thanks