Special cases (3)
uQuotes in strings:
ØShould be doubled (unless in 10g you use q ‘{}’) in the
string
ØShould NOT be used AT ALL for bind variables
create or replace function f_appendColumn_tx
...
Begin
v_sql_tx:=' update
'||i_table_tx||
' set
'||i_column_tx||'= '
||i_column_tx||'||''-''||:v01'||
' where '||i_pkColumn_tx||'=:v02'||
' returning
'||i_column_tx||' into :v03';
EXECUTE IMMEDIATE
v_sql_tx
USING i_newValue_tx, i_pkValue_nr
RETURNING INTO
v_out_tx;
return v_out_tx;
end;