Enterprise Manager Generic (MOSC)

MOSC Banner

Report Creatiion

edited Sep 3, 2012 2:40AM in Enterprise Manager Generic (MOSC) 3 commentsAnswered
Cloned canned report Oracle Database Configuration Summary.Removed all input constraints from query so it reads as follows:
begin
        declare
           type cursor_type IS REF CURSOR;
           result_cursor_out CURSOR_TYPE;
           tgt_guid_in  MGMT_IP_TGT_GUID_ARRAY;
           start_date_in DATE DEFAULT NULL;
           end_date_in  DATE DEFAULT NULL;
           query_string   VARCHAR(6000);
         begin
           result_cursor_out := ?;
           tgt_guid_in       := ?;
           start_date_in     := ?;
           end_date_in       := ?;
           query_string      :=
       'select o.database_name "DATABASE_NAME",
                o.characterset "CHARACTERSET",
                o.instance_name "INSTANCE_NAME",
                o.national_characterset "NATIONAL_CHARACTERSET",
                o.global_name "GLOBAL_NAME",
                o.log_mode "LOG_MODE",
                o.banner "BANNER",

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center