1 About This Recipe
Use this recipe to fetch data in small chunks from Oracle ATP.
Note:
Oracle provides this recipe as a sample only. The recipe is meant only for guidance, and is not warranted to be error-free. No support is provided for this recipe.
Overview
This recipe demonstrates how to use stored procedures to fetch supplier data in small chunks from Oracle ATP. 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.