36.16 GET_REPORT Function (Deprecated)

Note:

This API is deprecated and will be removed in a future release.

To execute the query of an Interactive Report within PL/SQL code, use OPEN_QUERY_CONTEXT Function Signature 1 in APEX_REGION instead.

This function returns an interactive report runtime query.

Syntax

APEX_IR.GET_REPORT(
    p_page_id   IN NUMBER,
    p_region_id IN NUMBER,
    p_report_id IN NUMBER   DEFAULT NULL,
    p_view      IN VARCHAR2 DEFAULT c_view_report )
    RETURN t_report;

Parameters

Parameter Description
p_page_id Page of the current Oracle APEX application that contains an interactive report.
p_region_id The interactive report region ID.
p_report_id The saved report ID within the current application page. If p_report_id is NULL, retrieves last viewed report query.
p_view

The view type available for the report. The values can be APEX_IR.C_VIEW_REPORT, APEX_IR.C_VIEW_GROUPBY, or APEX_IR.C_VIEW_PIVOT.

If p_view is NULL, retrieves the view currently used by the report. If the p_view passed does not exist for the current report, an error raises.

See Also:

OPEN_QUERY_CONTEXT Function Signature 1

Parent topic: APEX_IR