Open GoogleCodeExporter opened 9 years ago
This error occurred because selected table doesn't have all_tab_columns. In
ca.sqlpower.sql.jdbcwrapperOracleDatabaseMetaData:: getColumns() sql statement
trying to select all table columns, but as the table doesn't have tab_column it
return nothing.
I have tried to execute following sql command in DBVisualizer using same
database(test_environment) > schema (OE) .Table (ACTION_TABLE)
SELECT column_name, data_type from all_table_cols where table_name =
'ACTION_TABLE'
Generate error: 14:03:54 [SELECT - 0 row(s), 0.000 secs] [Error Code: 942,
SQL State: 42000] ORA-00942: table or view does not exist
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000
sec [0 successful, 0 warnings, 1 errors]
Instead if I execute :
SELECT column_name, data_type from all_nested_table_cols where table_name =
'ACTION_TABLE'
Result:
COLUMN_NAME DATA_TYPE
=========================
SYS_XDBPD$ XDB$RAW_LIST_T
SYS_NC_ROWINFO$ ACTION_T
SYS_NC_ARRAY_INDEX$ NUMBER
NESTED_TABLE_ID RAW
DATE_ACTIONED DATE
ACTIONED_BY VARCHAR2
To fix this issue, I think it need to modify sql stmt in
ca.sqlpower.sql.jdbcwrapperOracleDatabaseMetaData:: getColumns()
which will also able be to select all_nested_table_cols of the table.
Original comment by ki...@sqlpower.ca
on 30 May 2013 at 6:22
Original issue reported on code.google.com by
ki...@sqlpower.ca
on 16 May 2013 at 9:03