Defining a special view on the Oracle data source to use as a buffer for row results
This technique involves some administration on the foreign datasource and therefore is considered a result set option that is dependent on the foreign data source.
This technique allows you to:
Define views within the foreign data source
Use the result set buffer configuration of the view to access the data returned by the stored procedure