"Execute immediate" problem

[gandolf989]

Originally posted by 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; 

He is writing dynamic sql.
The tablename will change each time he runs this.