Ora-01000 Using Xmlelement/Xmltype Over Dblink
(Doc ID 1369617.1)
Last updated on FEBRUARY 19, 2019
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.1 to 11.2]
Information in this document applies to any platform.
In 11g, encountering ORA-01000 in queries that use xmltype/xmlelement over database links.
The ora-1000 error comes from the remote site.
The following reproduces this problem:
ERROR at line 1:
ORA-02063: preceding 2 lines from <dblink>
ORA-06512: at line 7
In remote site: ora-1000
Set session_cached_cursors=0 but this may lead to performance decrease
Upgraded to 11g, the problem does not reproduce with earlier releases.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document