OPEN_QUERY_CONTEXT Procedure

This procedure enables plug-in developers to open a query context based on the current region source. All data source information that the query retrieves is 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 20-31 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.