A script-enabled browser is required for this page to function properly.

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:

A stored procedure returns data to a data block by using either a ref cursor or a table of records.

 

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