Obtain the column value

Dicas do Oracle Forms Builder - Blocos, Itens, LOV, Canvas, Triggers, comandos, PLL, d2kwutil, FMB, Alert, menus, etc
  

Poston Mon, 01 Sep 2008 7:17 am

Good, how do I get a value of a column?

Code: Select all
table mytab(

COL1 number,
COL2 number,
COL3 number,
COL4 number
);

procedure myproc is
l_num  number;
begin
  ...
  l_num := 1;
  myGetValue('COL'|| to_char(l_num));
  ...
end;

procedure myGetValue ( coluna in varchar) is
l_out number;
begin
  ...
 
  select coluna <---????
    into  out
  from mytab
  ...
end;
how can I solve this case?

Forms 6i and DB X Thanks Joneto
Joneto
Location: Portugal

Poston Mon, 01 Sep 2008 11:35 am

Hi ... try to take a peek in this topic to see if it helps viewtopic.php?t=216 ow look for \"execute immediate\" abrçs
rodfbar
Location: Batatais - SP


  • See also
    Replies
    Views
    Last Post


Return to Forms

Who is online

Users browsing this forum: Bing [Bot] and 4 guests