If you make a change to the structure of a table or view within Central Biotics (including extensible tables) at any point in the future, please run the following PL/SQL.

SET SERVEROUTPUT ON;
EXEC VALIDATE_NSX_VIEWS();

The process of publishing data to NatureServe Explorer relies upon views which have names starting with NSX_VW_. Some of these views rely upon other views and/or data stored in extensible tables, so it is important to make sure they still work after any change is made to the database structure.

This procedure tests that each of the NSX_VW views still works. It runs a count(*) query against all views starting with this prefix, and prints out one of following two lines for each view:

NSX_VW_XXX is OK and contains YYY rows
or
NSX_VW_XXX is invalid

If you see the latter anywhere in the output, please either contact me or create a new Explorer 2.0 JIRA issue immediately.