Using Returning Clauses
u If you build statements with a RETURNING clause, it should be also used in dynamic SQL.
ufunction f_appendColumn_tx (i_table_tx,
u  i_column_tx,i_newValue_tx,i_pkColumn_tx,i_pkValue_nr)
ureturn varchar2 is
u  v_sql_tx  varchar2(32000);
u  v_out_tx  varchar2(256);
uBegin
u  v_sql_tx:='update '||i_table_tx||
u      ' set '||i_column_tx||'='||
u               i_column_tx||'||:v01'||
u      ' where  '||i_pkColumn_tx||'=:v02'||
u      ' returning '||i_column_tx||' into :v03';
u  EXECUTE IMMEDIATE v_sql_tx
u  USING i_newValue_tx, i_pkValue_nr
u  RETURNING INTO v_out_tx;
u  return v_out_tx;
uend;