#616 Oracle Object Type Columns are not Displayed in the SQL Results Panel

[Malcolm Boekhoff]

In an Oracle database, we have various TYPE's defined and they are allowed to be column values

It would be nice if SquirrelSql displayed object TYPE columns in the SQL tab, because they currently just show as "<error>"</error>

The UPLRATE column shown here contains a TYPE which I can view in the Object tree, so I'm wondering if we can get it to be viewed by e.g. double-clicking the cell (this is what you have to do in SQLDeveloper)

---------------------
| PRODUCT | UPLRATE |
| ------- | ------- |
| <null>  | <Error> |
---------------------

[Gerd Wagner]

You may try the following:
Got to menu File --> Global Preferences --> tab "Data Typ Controls" --> sections "SQL Other ..." and "Unknown Data Types ..." --> For both check "Read contents when table is first loaded and display as string"

[Malcolm Boekhoff]

Yes I already tried that, the column(s) appear as "<error>"
I found the same problem with Toad, so we have to list out every field in the SELECT clause instead</error>

[Gerd Wagner]

You may check SQuirreL's log for error messages after you executed an SQL that causes the problem. Please feel free to post those messages here.