15.32 OPEN_QUERY_CONTEXT Procedure
This procedure is for Plug-In developers to open a query context based on the current region source. All Data Source information will be retrieved from the Plug-In region metadata.
Syntax
FUNCTION OPEN_QUERY_CONTEXT (
p_columns IN t_columns DEFAULT c_empty_columns,
--
p_filters IN t_filters DEFAULT c_empty_filters,
p_order_bys IN t_order_bys DEFAULT c_empty_order_bys,
--
p_first_row IN PLS_INTEGER DEFAULT NULL,
p_max_rows IN PLS_INTEGER DEFAULT NULL,
--
p_total_row_count IN BOOLEAN DEFAULT FALSE,
p_total_row_count_limit IN NUMBER DEFAULT NULL,
--
p_sql_parameters IN t_parameters DEFAULT c_empty_parameters;
Parameters
Table 15-30 OPEN_QUERY_CONTEXT Procedure Parameters
Parameter | Description |
---|---|
|
Columns to be selected. |
p_filters |
Filters to be passed to the query context. |
p_order_bys |
Order by expressions to be passed to the query context. |
p_first_row |
First row to be fetched from the result set. |
p_max_rows |
Maximum amount of rows to be fetched. |
p_total_row_count |
Whether to determine the total row count. |
p_total_row_count_limit |
Upper boundary for total row count computation. |
p_sql_parameters |
Additional bind variables to be used for the SQL query. |
Parent topic: APEX_EXEC