Blitz Report Parameter Comparison between environments

Description

Categories
Enginatics
Repository
GitHub
Shows Blitz Report parameter differences between the local and a remote database server.

Requires following view to be created on the remote environment to avoid ORA-64202: remote temporary or abstract LOB locator is encountered

create or replace view xxen_report_parameters_v_ as
select
xrpv.*,
dbms_lob.substr(xxen_util.clob_substrb(xrpv.sql_text,4000,1)) sql_text_short,
dbms_lob.substr(xxen_util.clob_substrb(xrpv.lov_query,4000,1)) lov_query_short,
length(xrpv.sql_text) sql_length,
count(*) over (partition by xrpv.report_id) parameter_count
from
xxen_report_parameters_v xrpv;

SQL 86 lines

Parameters 4

ParameterTypeList of values SQL
Remote DatabaseLOV
<parameter_value>
CategoryLOV
regexp_like(xrpv.category,'(^|, )'||:category||'(, |$)')
Report Name likeLOV
xrpv.report_name like :report_name_like
Show Differences onlyLOV
(
nvl(x.report_name,'x')<>nvl(x.report_name_remote,'x') or
x.display_sequence_diff='Y' or
x.sql_diff='Y' or
x.parameter_type_diff='Y' or
x.lov_query_diff='Y' or
x.matching_value_diff='Y' or
x.default_value_diff='Y' or
x.descr_diff='Y'
)