ufunction F_GET_COLUMN_TX
u (i_table_tx,i_showColumn_tx,i_pkColumn_tx,i_pkValue_nr)
ureturn varchar2 is
u v_out_tx
varchar2(4000);
u v_sql_tx
varchar2(32000);
uBegin
u ...
u v_sql_tx:=' select
'||i_showColumn_tx||
u ' from
'||i_table_tx||
u ' where
'||i_pkColumn_tx||'=:v01';
u EXECUTE IMMEDIATE
v_sql_tx INTO v_out_tx
u USING i_pkValue_nr;
u
u return v_out_tx;
uend;