This discussion is archived
6 Replies Latest reply: Apr 29, 2013 1:24 AM by redy007 RSS

Not working insert of selected value from select list apex 4.2

redy007 Newbie
Currently Being Moderated
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?

Legend

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