Oracle Forms & Reports
  • :BLOCK_NAME.ITEM_NAME is the value of an item.
    BLOCK_NAME.ITEM_NAME is the item itself.
  • To create and fill up list item:
    1. Create an item and change it’s item type propety to list item from property palette .
    2. Create a form level trigger by selecting  when-new-form-instance trigger in the object navigator.
      declare

      rg_name  VARCHAR2(40) := ‘RECORD_GROUP11′;
      rg_id    RecordGroup;
      gc_id    GroupColumn;
      errcode number;

      begin
      rg_id := Find_Group(rg_name);
      if not Id_Null(rg_id) then
      Delete_Group(rg_id);
      else if Id_Null(rg_id) then
      rg_id := create_group_from_query(rg_name,’SELECT  to_char(city) city, to_char(locations_id) location_id from locations’);
      errcode := Populate_Group( rg_id);
      clear_list(’CONTROL.DEPARTMENT_NAME’);
      message(errcode);
      populate_list(’CONTROL.DEPARTMENT_NAME’,rg_id);
      end if;
      end if;

      end;

      Compile pl/sql code.