Home » SQL & PL/SQL » SQL & PL/SQL » Document contains too many nodes error message select query search all columns for a string (11)
Document contains too many nodes error message select query search all columns for a string [message #573367] Thu, 27 December 2012 06:24 Go to next message
cplusplus1
Messages: 40
Registered: October 2012
Location: usa
Member
I am using the below query searching for a string within the table all columns: %2027171%

I am getting this error:
ORA-31186: Document contains too many nodes
31186. 00000 - "Document contains too many nodes"
*Cause: Unable to load the document because it has exceeded
the maximum allocated number of DOM nodes.
*Action: Reduces the size of the document.



select * from T_SS_BSYRRVP
where rowid in (select cast(extractvalue(xmltype(data_row), '/ROW/RI') as rowid) ri
from (select cast(column_value as varchar2(4000)) data_row
from table(xmlsequence(extract(xmltype(dbms_xmlgen.getxml('select rowid ri, a.* from T_SS_BSYRRVP a')),'/ROWSET/ROW')))
)
where data_row like '%2027171%'
)




Thank you very much for the helpful info.
Re: Document contains too many nodes error message select query search all columns for a string [message #573371 is a reply to message #573367] Thu, 27 December 2012 07:53 Go to previous message
Michel Cadot
Messages: 58933
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Search for "findstring" function on AskTom.

Regards
Michel
Previous Topic: Delete Duplicate Records using Anaytical function
Next Topic: Problem with cursor
Goto Forum:
  


Current Time: Thu Aug 28 18:41:21 CDT 2014

Total time taken to generate the page: 0.07051 seconds