About This Recipe
This recipe demonstrates how to use stored procedures to fetch supplier data in small chunks from Oracle Autonomous Transaction Processing. You can use the recipe to implement use cases where due to service limits data cannot be fetched in bulk, but have to be fetched in smaller chunks.
To use the recipe, you must install the recipe and configure the connections and other resources within it.
The recipe uses a database package XX_SUPPLIERS_PAGINATION_PKG. The package uses a PL/SQL procedure GET_SUPPLIERS_PAGINATION_PROC which accepts the following input parameters:
i_limit: A numeric parameter that specifies how many records are to be fetched from the ATP database at a time.i_page: A numeric parameter that specifies which page's data have to be fetched.