how to trapping error in SQL using SYS.DBMS_XMLGEN [message #640201] |
Thu, 23 July 2015 09:47 |
|
Freewilly3d
Messages: 2 Registered: July 2015
|
Junior Member |
|
|
the following query is part of a more complex query I'm using to streamline testing dimensional integrity of a data warehouse and will fail when a table in my source table is not found in the schema; I get an error like:
Error during Execute
S1000(19202)[Oracle][ODBC][Ora]ORA-19202: Error occurred in XML processing
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_XMLGEN", line 176
ORA-06512: at line 1
I would like to do something like an iferror() ...
SELECT TABLE_NAME,
TO_NUMBER(EXTRACTVALUE(XMLTYPE(DBMS_XMLGEN.GETXML('SELECT COUNT(*) CNT FROM '||TABLE_NAME )),'/ROWSET/ROW/CNT')) AS COUNT
FROM pldsbx.wstandketest2
where
table_name like 'WC%F'
AND FKTABLE_NAME <> 'IGNORE'
group by table_name
|
|
|
|
|
|
|