4 Replies Latest reply: Jan 30, 2014 5:50 PM by Phil in Sydney RSS

A Quick Question on get value of an item via a variable.

Phil in Sydney Newbie
Currently Being Moderated

Hi there,


My database is 11gR2, form server is 10g.

I have a canvas named as canvas14, there is a multi-tab in it (tab1,tab2).

In the 'Key-Exit' trigger, I would like to get current tab name and do something then exit_form.

To get the tab name, I used a function as following.


FUNCTION getTabName RETURN varchar2 IS

  tp_nm   VARCHAR2(30);

  tp_id   TAB_PAGE;

  tp_lb   VARCHAR2(30);


  tp_nm := GET_CANVAS_PROPERTY('CANVAS14', topmost_tab_page);

  tp_id := FIND_TAB_PAGE(tp_nm);

  tp_lb := GET_TAB_PAGE_PROPERTY(tp_id, label);

  return tp_lb;



In Key-Exit trigger, my part of code is following.


v_name := getTabName;

v_item := ':' || v_name||'.des' ;


if  v_item is not null then




end if;


v_item is :tab1.des now. I want to get the value of :tab1.des.

How to get the value of v_item, not the variable itself?


Thanks in advance.




  • Correct Answers - 10 points
  • Helpful Answers - 5 points