RWB Imported SQL Validation

Description
Categories: RWB
Columns: Report Name, Error Message, Rwb Report Id, Category, Sql Text ...
Validates all Polaris Reporting Workbench reports after migration to Blitz Report for valid SQL syntax
select
x.*
from
(
select
xrv.report_name,
xxen_report.validate_sql(xrv.sql_text_full,'parse') error_message,
regexp_substr(xrv.description,'Report ID: (\d+)',1,1,null,1) rwb_report_id,
xrv.category,
xrv.sql_text
from
xxen_reports_v xrv
where
1=1
) x
where
x.error_message is not null
order by
x.report_name
Parameter Name SQL text Validation
Category
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
)
LOV