8.17 GET_DATA_REPORTER_REMAP Function

This function gets the remapped schema (owner) for the supplied schema.

Syntax

FUNCTION apex_application_install.get_data_reporter_remap (
    p_schema_from    IN   VARCHAR2 )
    RETURN VARCHAR2;

Parameters

Parameter	Description
p_schema_from	The source schema to map from.

Example

The following example returns the remapped schema for the supplied schema name from the APEX_APPLICATION_INSTALL package, set via a call to apex_application_install.add_data_reporter_remap. If no mapping exists then the supplied schema is returned.

declare
    l_schema varchar2(30);
begin
    l_schema := apex_application_install.get_data_reporter_remap( 'HR' );
end;