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