DEFINE_ARRAY v16
The DEFINE_ARRAY
procedure defines the collection for a column into which you want to fetch rows with a FETCH_ROWS call. You can use this procedure to fetch multiple rows from a single SELECT statement.
When you fetch rows, they are copied into DBMS_SQL buffers until you run a COLUMN_VALUE call, which copies the rows into the table that was passed as an argument to the COLUMN_VALUE call.
Parameters
c
ID of the cursor to which you want to bind an array.
position
Relative position of the column in the array being defined. The first column is position 1.
table_variable
A datatype that can be any one of the following matching pairs:
Datatype | Description |
---|---|
<bflt_tab> | FLOAT_TABLE |
<bl_tab> | BLOB_TABLE |
<cl_tab> | CLOB_TABLE |
<c_tab> | VARCHAR2_TABLE |
<n_tab> | NUMBER_TABLE |
<tms_tab> | TIMESTAMP_TABLE |
<int_tab> | INTEGER_TABLE |
<rid_tab> | ROWID_TABLE |
<txt_tab> | TEXT_TABLE |
cnt
Number of rows to fetch. Must be a positive integer.
lower_bnd
Results are copied into the collection, starting at this lower bound index.
Example
- On this page
- Parameters
- Example