3 Replies Latest reply on Dec 11, 2013 11:14 AM by Marco Gralike

    Getting error "no more data to read from socket" when trying to update xmlType column

    9666bfd6-8f38-4086-a3f6-1c8781502d7c

      Hi,

       

      I am using Oracle 11g Enterprise Edition Release 11.2 and am trying to update attributes in my xml. The query is as below:

      update broadcast_sheets set object_value=updateXml(object_value,'/game/@modifiedBy','arvind','/game/@createdBy','arvind') where game_type='NHL' and season_year=2013 and season_game_id=1;

       

      Here i am trying to modify values of two attributes under the root element game. When i try the same query with single attribute ( query given below) it works fine.

      update broadcast_sheets set object_value=updateXml(object_value,'/game/@modifiedBy','arvind') where game_type='NHL' and season_year=2013 and season_game_id=1;

       

      What could possibly be causing it?