Using Stored Procedures as Block DataSources
Using a stored procedure as a block datasource is a more advanced option. Base a data block on a stored procedure when you want to:
- increase control and security
- query and updatemultiple tables
- perform complex computations
- perform validation and DML on the server-side
- encapsulate logic within a subprogram
- reduce network traffic through array processing
A stored procedure returns data to a data block by using either a ref cursor or a table of records.
Related topics
DML Array Size property
DML Data Target Type property
Query All Records property
Query Data Source Type property
Guidelines for choosing block datasources
Using tables as block datasources
Using transactional triggers as block datasources
Using the FROM clause as a block datasource
About array processing