A table parameter is a non-constant parameter. This means that the TPF must be in the execution state to retrieve table parameters.
The TPF can retrieve the table parameter from these methods:
_open_extfn
_fetch_into_extfn
_fetch_block_extfn
_rewind_extfn
_evaluate_extfn
To consume a table parameter, the TPF must:
Obtain a Table Object
The TPF obtains a table object for the table parameter using the get_value method of a_v4_extfn_proc_context.
Open the Result Set
Once a table object has been obtained using get_value, the TPF must open a result set on the table object using the open_result_set method of a_v4_extfn_proc_context before it can fetch any rows.
Close the Result Set
Once the TPF is finished processing table data, it closes the open result set using the close_result_set method of a_v4_extfn_proc_context.