How to populate list in oracle form using a dynamic recordgroup based on an Sql which has varibales to be parsed at run time.

How to populate list in oracle form using a dynamic recordgroup based on an Sql which has varibales to be parsed at run time.
haf70Asked:
Who is Participating?
 
haf70Connect With a Mentor Author Commented:
Found solution

put 3 quotes in front and back of the variable within the query variable.
0
 
flow01Connect With a Mentor Commented:
to get the idea : can you give some examples of what should be dynamic and which variables are involved ?
In an record group you can refer to forms globals and block.items.
0
 
haf70Author Commented:
Please see the procedure below which I am using to populate the the record group.
I am facing problem with the variables used in the query string.


PROCEDURE populate_hr_list IS
rg_id   RECORDGROUP :=NULL;
V_RG_NAME VARCHAR2(100);
V_STATUS NUMBER;
v_query varchar2(1000) :=NULL;
BEGIN
      V_RG_NAME := 'hr';
      CLEAR_LIST(:VARS.L1);
      
     rg_id := FIND_GROUP(V_RG_NAME);
      IF NOT ID_NULL(rg_id) THEN
         DELETE_GROUP(rg_id);
     END IF;
     v_query := 'select '|| :vars.a||', '|| :vars.b||' from dual';
     rg_id :=CREATE_GROUP_FROM_QUERY(V_RG_NAME ,V_QUERY);
     IF NOT ID_NULL(rg_id) THEN
       V_STATUS := POPULATE_GROUP(rg_id);
       POPULATE_LIST(:VARS.L1,rg_id);
    END IF;
    DELETE_GROUP(rg_id);
end;
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.