Recent changes to 616: Oracle Object Type Columns are not Displayed in the SQL Results Panelhttps://sourceforge.net/p/squirrel-sql/feature-requests/616/2024-09-10T18:28:33.006000ZRecent changes to 616: Oracle Object Type Columns are not Displayed in the SQL Results Panel#616 Oracle Object Type Columns are not Displayed in the SQL Results Panel2024-09-10T18:28:33.006000Z2024-09-10T18:28:33.006000ZGerd Wagnerhttps://sourceforge.net/u/gerdwagner/https://sourceforge.netd4a8d30e00e09e91c75c585795567833ccd07a65<div class="markdown_content"><p>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.</p></div>#616 Oracle Object Type Columns are not Displayed in the SQL Results Panel2024-09-10T00:17:00.687000Z2024-09-10T00:17:00.687000ZMalcolm Boekhoffhttps://sourceforge.net/u/boekhoffm/https://sourceforge.net7e3200584a2645cc35bae5c2e2c5ad6cd74c19e1<div class="markdown_content"><p>Yes I already tried that, the column(s) appear as "<error>"<br/>
I found the same problem with Toad, so we have to list out every field in the SELECT clause instead</error></p></div>#616 Oracle Object Type Columns are not Displayed in the SQL Results Panel2024-09-08T19:26:11.422000Z2024-09-08T19:26:11.422000ZGerd Wagnerhttps://sourceforge.net/u/gerdwagner/https://sourceforge.netcb1dfc5c9db6f9795660bb9dc729c95b240f14ee<div class="markdown_content"><p>You may try the following:<br/>
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"</p></div>Oracle Object Type Columns are not Displayed in the SQL Results Panel2024-09-04T07:19:41.750000Z2024-09-04T07:19:41.750000ZMalcolm Boekhoffhttps://sourceforge.net/u/boekhoffm/https://sourceforge.net12f16025b7291c2ca916c6e5462b428928be1c63<div class="markdown_content"><p>In an Oracle database, we have various TYPE's defined and they are allowed to be column values</p>
<p>It would be nice if SquirrelSql displayed object TYPE columns in the SQL tab, because they currently just show as "<error>"</error></p>
<p>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)</p>
<div class="codehilite"><pre><span></span><code>---------------------
| PRODUCT | UPLRATE |
| ------- | ------- |
| <null> | <Error> |
---------------------
</code></pre></div>
</div>