The other Oracle developers in the office just cringe...
This does seem to be an area where precise configuration of the environment is required. For example, testing your case against an 11.2 XE DB...
- +188.8.131.52 instant client: Worksheet returns null for OCI or Thin JDBC drivers, but Object Viewer does work with Thin.
- +184.108.40.206 instant client +OCI, both Worksheet and Object Viewer get an error.., no orageneric11 in java.library.path
- +220.127.116.11 instant client: +Thin, Object Viewer works, but Worksheet gets Only LOB or String Storage is supported in Thin XMLType
Perhaps a full 12c client might work better, but require a renaming trick (make a copy of orageneric12.dll and rename to orageneric11.dll). Not really sure -- maybe someone else with more knowledge can comment.
It works for me in 4.1 with just the straight 18.104.22.168 jdbc driver going against 22.214.171.124, but that's nowhere near what you're using of course.
Gary's right, the 'matrix' of things to get correct here for the best XML support can be fun. I would advise opening an SR with My Oracle Support.
Thanks for the replies. 'fun' is not a word I would use for this stuff we're only using XML because it is a badly implemented schema
I am not sure I would be able to get an Oracle 12 client yet as they are pretty strict about us downloading things here.
At least I do have a workaround using sqlplus.
I will raise an SR.