View Single Post
  #3 (permalink)  
Old 03-18-10, 14:13
vinodkumarn vinodkumarn is offline
Registered User
 
Join Date: Mar 2010
Posts: 3
i did create function as folllows

create or replace function get_value
(p_aid in number
,p_col_name in varchar2)
return varchar2 is
l_pa procurementaction%rowtype;
b varchar2(500);
begin
l_pa := ina_pkg.get_pa(p_aid);
execute immediate 'select l_pa.'||p_col_name||' from dual' into b;
return b;
end;

but when try to execute the function by following i get error

select get_value(19913,'awardnbr') from dual

ora-00904 lpa.awardnbr invalid identifier
Reply With Quote