input
possible output Shape column
input
possible output Shape column
Use the Oracle Spatial writer.
If your licensing options do not allow you to use this writer, this workaround using a non-spatial Oracle writer and some post-processing may be of use.
Thanks @geomancer