Could you please give me an example Select (as simple as possible)?
Since the shape field is likely a user defined type, I need to check to see how other tools return the value, as it likely a complex type, and we wouldn't be able to display it VS Code results.
Just follow the instructions here in order to create testdata:
Then this select fails:
select * from cola_markets;
This one works:
select MKT_ID from cola_markets;
In my oppinion there would be no need to show the shape itsself, it would be enough to show some text in this column, e.g. [MDSYS.SDO_GEOMETRY], just like the Oracle Developer does.
Allthoug a better solution would be to display the WKT-Representation by default (