Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"ORA-00904 : XMLRoot invalid identifier"

652696Dec 20 2008 — edited Dec 21 2008

Hi,

I need your help. I'm getting "ORA-00904 : XMLRoot invalid identifier" when use the XML SQL in a prod machine, but in my notebook run correct.

select XMLSerialize( CONTENT XMLRoot( XMLElement( ERRCOL_LIST
                                                          ,XMLAgg( XMLElement( ERRCOL_LIST_ITEM
                                                                              ,XMLForest( table_name     
                                                                                        ))))))
from ALL_TAB_COLUMNS

advanced thanks.

PS:Sorry, my english is very poor.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 18 2009

Added on Dec 20 2008

#performance-availability, #xml-db

6 comments

3,262 views