Skip to Main Content

Oracle Developer Tools for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unsupported column datatype

user1353826Apr 6 2021

Hi,
i'm getting "unsupported column datatype" on selecting columns with e. g. SDO GEOMETRY data type.
I think this problem can occur with other data types as well but i've not checked it out.
Is it possible to fix this with the next release (or at least deliver raw or null for these columns, or just leave it out in the resultset)

Thanks!

Comments

Christian.Shay -Oracle

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?

user1353826

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.

S3r4ph40

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.

S3r4ph40

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.

S3r4ph40

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.

S3r4ph40

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

Christian.Shay -Oracle

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!

S3r4ph40

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...

1 - 12

Post Details

Added on Apr 6 2021
12 comments
2,232 views