Errors when retrieving database catalog information

This application uses standard ways to retrieve the database catalog information (tables and columns info). But sometimes, an error can ocurr in specific database.

For this, we provide files with the name database.sch, where database is the type of the database accesed. For example Oracle.sch. See Connection to Source Information to know what is your database type.

If an error ocurr when trying to access the catalog info, the .sch is opened and the queries to read catalog information are read from that file. Below is the Oracle.sch file:

Tables=select OWNER TABLE_SCHEMA, TABLE_NAME, 'TABLE' TABLE_TYPE from ALL_TABLES union all select OWNER, VIEW_NAME, 'VIEW' from ALL_VIEWS order by 1, 2, 3
Columns=select COLUMN_NAME, DATA_TYPE from ALL_TAB_COLUMNS where OWNER = '<SCHEMA>' and TABLE_NAME = '<TABLE>'
Numeric=DECIMAL,FLOAT,INT,INTEGER,LONG,LONG RAW,NUMBER,RAW,REAL,SMALLINT
Char=CHAR,VARCHAR,VARCHAR2
Date=DATE

• Tables: Sql instruction to read tables and view from database catalog.
• Columns: Sql instruction to read column information from a specific table. <SCHEMA> and <TABLE> are substituted with the actual schema (owner) and table name.
• Numeric: Specific database types that get treated as a numeric type.
• Char: Specific database types that get treated as a char type.
• Date: Specific database types that get treated as a date type.

Feel free to make your own database files as needed.