This discussion is archived
3 Replies Latest reply: Dec 11, 2013 3:14 AM by MarcoGralike RSS

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

9666bfd6-8f38-4086-a3f6-1c8781502d7c Newbie
Currently Being Moderated

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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points