Blitz Report SQL Validation

Description

Categories: Enginatics
Repository: GitHub

Validates Blitz Reports for valid SQL syntax.
This can be useful after mass migrating reports from other tools such as Discoverer, Excl4apps, splashBI or Polaris Reporting Workbench into Blitz Report.

SQL 26 lines

select
y.*
from
(
select
x.*,
nvl2(x.error_message,'Error','Valid') validation_result
from
(
select
xrv.report_name,
xxen_report.validate_sql(case when :remove_lexicals='Y' then regexp_replace(xrv.sql_text_full,'&\w+') else xrv.sql_text_full end,'parse') error_message,
xrv.type_dsp type,
xrv.category,
xrv.sql_text,
regexp_substr(xrv.description,'Report ID: (\d+)',1,1,null,1) orig_report_id
from
xxen_reports_v xrv
where
1=1
) x
) y
where
2=2
order by
y.report_name

Parameters 4

Parameter

Type

List of values SQL

Report Name like

LOV

lower(xrv.report_name) like lower(:report_name_like)

Category

LOV

xrv.report_id in (
select
xrca.report_id
from
xxen_report_category_assigns xrca,
xxen_report_categories_v xrcv
where
xrcv.category=:category and
xrcv.category_id=xrca.category_id
)

Validation Result

LOV

y.validation_result=:validation_result

Remove &lexicals

LOV Oracle

Description

SQL 26 lines

Parameters 4

Find out more

Features

Download

FAQ