Report Creatiion
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",
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",
0