OraFAQ Forum: SQL & PL/SQL » Document contains too many nodes error message select query search all columns for a string

Home » SQL & PL/SQL » SQL & PL/SQL » Document contains too many nodes error message select query search all columns for a string (11)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Document contains too many nodes error message select query search all columns for a string [message #573367]

Thu, 27 December 2012 06:24

cplusplus1
Messages: 30
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.

Report message to a moderator