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
p_columns	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.