XML Database (MOSC)

MOSC Banner

ORA-19114 :Error during Running Query 11203 RAC db

edited Sep 17, 2013 12:46AM in XML Database (MOSC) 3 commentsAnswered
Hi Gurus,

I'm newbie with XML have no clue of these technology but got to support one datababse that uses XML heavily.Below query runs fine on 11.2.0.2 single instance db RHEL 5.6  but throws error in 11.2.0.3 RAC RHEL 6 which is recently migrated .

SELECT XMLQuery('STRING-join(FOR $name as attribute() in $itmCntntXml/((item|set_leader)/(item_information/@item_name|item_content/item_part/@part_name)|/item[item_information[string(@item_name)="Interactive"]]//interactive_with_response/interactive_file/@external_file_name)RETURN string($name),"__IBIS_DELIMITER__")' PASSING io.itm_cntnt_xml AS "itmCntntXml" RETURNING CONTENT).getStringVal() AS my_xml

FROM itm_obj io

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center