"Execute immediate" problem

[thomasp]

why dont you write it as

stmt1 varchar2(8000)
      := 'Update tabs.table_name set ID_CTLGRP = REPLACE(ID_CTLGRP,'''','_') WHERE ID_CTLGRP LIKE '%''%'';

EXECUTE IMMEDIATE STMT1;