34.3 CHANGE_REPORT_OWNER Procedure
This procedure changes the owner of a saved interactive report using a report ID. This procedure cannot change the owner of default interactive reports.
Syntax
APEX_IR.CHANGE_REPORT_OWNER (
p_report_id IN NUMBER,
p_old_owner IN VARCHAR2,
p_new_owner IN VARCHAR2);
Parameters
Table 34-3 CHANGE_REPORT_OWNER Procedure
Parameters | Description |
---|---|
|
The saved report ID within the current application page. |
|
The previous owner name to change from (case sensitive). The owner needs to a valid login user accessing the report. |
|
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.
BEGIN
APEX_IR.CHANGE_REPORT_OWNER (
p_report_id => 1235704029884282,
p_old_owner => 'JOHN',
p_new_owner => 'JOHN.DOE');
END;
Parent topic: APEX_IR