Under Oracle 11gR2 selecting a XMLTYPE across a DB link a remote site appears to be possible (although selecting a CLOB is not)
SELECT <XMLTYPE_COLUMN>
FROM <some_table>@<remote_site>
/
I’ve done some quick experimentation and the functionality does not appear to be constrained by size (have selected XML content of up to 50k).
The ability to select an XMLTYPE from a remote site seems to be a direct contradiction of the stated restrictions on XMLTypes as noted in the “Ohttp://docs.oracle.com/cd/E11882_01/appdev.112/e23094/appjspec.htm#ADXDB3700racle® XML DB Developer's Guide 11g Release 2 (11.2)”
Namely: “•No XMLType Access over Database Links – Access to remote XMLType tables or columns is not supported.”
So my question is this: can we rely on the ability to SELECT and XML type across a DB link, or may this behavior be “fixed” in a future release? Can anyone explain why it works or what Oracle’s official position is?
Thanks much,
- - martin