Basic Example – The Code
ufunction F_GET_COLUMN_TX
(i_table_tx,i_showColumn_tx,i_pkColumn_tx,i_pkValue_nr)
return varchar2 is
v_out_tx
varchar2(4000);
v_sql_tx varchar2(32000);
uBegin
if user='SCOTT' and
i_showColumn_tx = 'SAL' then
u return '[Not enough
privileges]';
end if;
v_sql_tx:=' select
'||i_showColumn_tx||
' from '||i_table_tx||
' where
'||i_pkColumn_tx||'='||i_pkValue_nr;
EXECUTE IMMEDIATE v_sql_tx INTO v_out_tx;
return v_out_tx;
end;