oracle forms 6i, how to display data thru combo box

Posted on 2006-05-22
Last Modified: 2013-12-12

I want to display a combo box on a form based on the field(based on a query) from the table. when the user selects a value, i call oracle reports and generate a report.

how do i do that??

I created a data block and added a list item with type combo box.but i keep getting this error..

FRM-30191: No list items defined for required poplist.
List listname
Item: ItemName

Question by:Pra4444
    LVL 2

    Accepted Solution

    Try this:

    First set the following values to the list:

    List style: Poplist
    Elements in list: add one element with value 'X'
    Mapping of Other Values: X
    Initial value: empty
    Required: No

    Then in the program (when-new-form-instance trigger):


      CURSOR c_report_list IS
        [your query with report descriptions and file names];
      i number := 1;


    Clear_list ('report_list');

      for r in c_report_list loop
              Add_list_element ('report_list', i, r.description, r.filename);
              i := i+1;
      end loop;

    Set_item_property ('report_list', REQUIRED, PROPERTY_TRUE);
    -- Omit next line if you want the list to be initially empty
    :report_list := get_list_element_value('report_list', 1);


    (I assume the poplist is called report_list)

    Expert Comment

    I have a form with 15 list item's (more or less), every one of them has a very fast query behind, and none of them reach more than 20 elements, they usually have around 9 elements.

    My problem is: the form is too slow! is there any property I can set up in order to get the form faster?

    Database blocks of the form are pretty new, and they are almost empty, it were supposed to be fast.


    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now