6 Replies Latest reply: Apr 29, 2013 3:24 AM by redy007 RSS

    Not working insert of selected value from select list apex 4.2

    redy007
      Hello all,

      I have problem on submiting tabular form value of select list column (Select List (query based LOV)). The tabular form is created based on view. Column named NADRAZENA_POLOZKA (apex_application.g_f05(i) is equal). Everything else on same row is inserted right into the table except NADRAZENA_POLOZKA. When I changed apex_application.g_f05(i) for static value it's inserted too. So problem would be somewhere on Select List (query based LOV).

      List of values definition:
      SELECT distinct VERZE r, POLOZKA d
      from "#OWNER#"."PRIDEJ_KOMPONENTU"
      where instr(:P13_POLOZKY, '*' || POLOZKA || '*') > 0
      AND PROSTREDI_ZAKAZNIK = :P13_CUST_NAME
      AND PROSTREDI_VRSTVA = :P13_LAYER_BSC
      I tried to change Reference Table Name and Reference Column Name and even definition of LOV.

      HTML code:
      <td headers="NAZEV">
      <label for="f02_0002" class="hideMeButHearMe">Nazev</label>
      <input type="text" name="f02" size="30" maxlength="2000" value="" id="f02_0002"/>ev
      </td>
      <td headers="VERZE">
      <label for="f03_0002" class="hideMeButHearMe">Verze</label>
      <input type="text" name="f03" size="30" maxlength="2000" value="" id="f03_0002"/>ev
      </td>
      <td headers="RELEASE_NOTES">
      <label for="f04_0002" class="hideMeButHearMe">Release Notes</label>
      <input type="text" name="f04" size="35" maxlength="2000" value="" id="f04_0002"/>ev
      </td>
      <td headers="NADRAZENA_POLOZKA">
      <label for="f05_0002" class="hideMeButHearMe">
      <select name="f05" id="f05_0002">ev
      <option value="48" selected="selected"/>
      <option value="132">RZB_UDEBS20130314HOTFIX_01.SQL </option>
      </select>
      </td>
      <td headers="KOMENTAR">
      <label for="f06_0002" class="hideMeButHearMe">Komentar</label>
      <input type="text" name="f06" size="45" maxlength="2000" value="" id="f06_0002"/>ev
      <input type="hidden" name="f01" value="" id="f01_0002"/>ev
      <input type="hidden" name="f07" value="" id="f07_0002"/>ev
      <input type="hidden" name="f08" value="" id="f08_0002"/>ev
      <input type="hidden" id="fcs_0002" name="fcs" value="A884FA378C851786DDFE3A33709CB23C"/>ev
      <input type="hidden" id="frowid_0002" name="frowid" value=""/>ev
      <input type="hidden" id="fcud_0002" name="fcud" value="D"/>ev
      </td>
      CREATE TABLE "OBE"."KOMPONENTA"
        (
          "POLOZKA"           NUMBER NOT NULL ENABLE,
          "NAZEV"             VARCHAR2(45 BYTE) NOT NULL ENABLE,
          "VERZE"             VARCHAR2(45 BYTE) NOT NULL ENABLE,
          "ODESLANO"          CHAR(1 CHAR) DEFAULT 'N',
          "ZOBRAZENI_DA"      VARCHAR2(45 BYTE),
          "RELEASE_NOTES"     VARCHAR2(45 BYTE),
          "NADRAZENA_POLOZKA" NUMBER,
          CONSTRAINT "SYS_C0096068" PRIMARY KEY ("POLOZKA") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "APEX_2089123293345627" ENABLE,
          CONSTRAINT "KOMPONENTA_KOMPONENTA_FK" FOREIGN KEY ("NADRAZENA_POLOZKA") REFERENCES "OBE"."KOMPONENTA" ("POLOZKA") DEFERRABLE INITIALLY DEFERRED ENABLE
        )
      insert into KOMPONENTA (NAZEV,VERZE,POLOZKA,RELEASE_NOTES,NADRAZENA_POLOZKA) values (apex_application.g_f02(i),apex_application.g_f03(i), v_sequence,apex_application.g_f04(i),apex_application.g_f05(i));
      Could you help me?