Oracle Developer Tools for VS Code

Thanks. As you see we currently don't support User Defined Types (which includes spatial types, nested tables, varrays, etc).
Is this happening in a script? Or are you primarily using Oracle Explorer to View Data?
If a script, I assume you can't change the script or it would be difficult to do so?

Hi, i just use a single statement like select * from table.
In most cases i don't know if there is a unsupported datatype in the table.
So for me it would be fine when the query is just showing empty/null value for these columns or a short hint that it can't be displayed.
Perhaps it could be fixed in the next version.

Any update on this? The ability to view and update fields with SDO GEOMETRY data field would be useful. Please keep us posted...

UDT support in the results window is a fairly large project so it may be a while.
What might come sooner than that is a empty field for unsupported data types rather than erroring the query.

That would do fine... The geometry is not what I would want to edit anyway. Just access to the fields would be a huge help.

Any update on when this workaround might be coming? Or if?

It should be coming relatively soon, within a release or two. I believe we will most likely show the data as JSON.

Still showing 'Unsupported column datatype' when trying to access a table with geometry... Any updates on this?

Hi there,
This will be fixed in the next release (21.4) - we will show the data as JSON. I will try to remember to ping this thread when we release it.

Hi, we now support User Definied Types in select lists in version 21.4.0. Please try it out and let me know what you think!

Hi, we now support User Defined Types in select lists in version 21.4.0. Please try it out and let me know what you think!

It works like a charm! Awesome, I've been wanting this for years, lol... Thanks for listening and thank the devs for getting it done! This will save me so much time... Letting my team know asap...