We have a table with the following structure. Create and item on the page with the following details. In the dynamic action tab we create a new dynamic action under the "Change" event, with an action under "True".

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

CREATE TABLE t1 (
  code VARCHAR2(10)
);

Name: P1_LIST
Type: Select List
LOV Type: Static Values
Static Values: One, ONE, Two, TWO
Display Extra Values: No
Display Null Value: No

Name: P1_LIST_CHANGE
Event: Change
Selection Type: Item(s)
Item(s): P1_LIST

Action: Execute PL/SQL Code
PL/SQL Code:

BEGIN
  INSERT INTO t1 VALUES (:P1_LIST);
  COMMIT;
END;

Items to Submit: {null}

When you run the application, changes to the list will trigger the dynamic action, but it will keep inserting the value in session state. It won't insert the changed value. In this example, every change will result in the value "ONE" being inserted into the table. Go back to the dynamic action, and set the "True" action as follows. Rerun the application. You will find any change to the list item results in the selected value being used for the insert, and set in the session state, without a submit of the whole page. In this example, the values "TWO" and "ONE" are inserted into the table, as the list value changes. For more information see: - APEX Articles Hope this helps. Regards Tim...

1

Items to Submit: P1_LIST