Ora-01000 Using Xmlelement/Xmltype Over Dblink
(Doc ID 1369617.1)
Last updated on FEBRUARY 19, 2019
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [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:
for rec in (select * from dba_objects where rownum<=5000) loop
v_SQLQuery:='SELECT xmlelement ("TEST",object_name) FROM DBA_OBJECTS@dbl1
where owner='''||rec.owner||''' and
EXECUTE IMMEDIATE v_SQLQuery INTO v_xmltype;
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