CHANGE_REPORT_OWNER Procedure

This procedure changes the owner of a saved interactive grid report using a report ID. This procedure cannot change the owner of default interactive grid report.

Syntax

APEX_IG.CHANGE_REPORT_OWNER (
    p_application_id IN NUMBER DEFAULT wwv_flow.g_flow_id,
    p_report_id      IN NUMBER,
    p_old_owner      IN VARCHAR2,
    p_new_owner      IN VARCHAR2);

Parameters

Table 19-3 CHANGE_REPORT_OWNER Procedure

Parameters	Description
`p_application_id`	The application ID containing the interactive grid. If `p_application_id` is NULL, it defaults to the application ID in `wwv_flow.g_flow_id`.
`p_report_id`	The saved report ID within the current application page.
`p_old_owner`	The previous owner name to change from (case sensitive). The owner needs to a valid login user accessing the report.
`p_new_owner`	The new owner name to change to (case sensitive). The owner must be a valid login user accessing the report.

Example

This example shows how to use CHANGE_REPORT_OWNER procedure to change the old owner name of JOHN to the new owner name of JOHN.DOE for a saved report. The saved report has a report ID of 1235704029884282 and resides in the application with ID 100.

BEGIN
    APEX_IG.CHANGE_REPORT_OWNER (
        P_application_id => 100,
        p_report_id      => 1235704029884282,
        p_old_owner      => 'JOHN',
        p_new_owner      => 'JOHN.DOE');
END;
END;