Blitz Report LOV Comparison between environments

Description

Categories
Enginatics
Repository
GitHub
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_parameter_lovs_v_ as
select
xrplv.*,
dbms_lob.substr(xxen_util.clob_substrb(xrplv.lov_query,4000,1)) lov_query_short
from
xxen_report_parameter_lovs_v xrplv;

SQL 72 lines

Parameters 1

ParameterTypeList of values SQL
Remote DatabaseLOV
<parameter_value>