ORA-19114 :Error during Running Query 11203 RAC db
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_xmlFROM itm_obj io