'why APEX collection attribute not updating in Dynamic action on change event?

I am trying change the collection attribute in OnChange event below. But, collection is not updating with new value. Can anyone help me if am missing anything?

Item Name - P2_CHANGE_ENTRY Created 3 dynamic actions as below - 

1. SetValue
    JavaScript Expression => this.triggeringElement.value
    Affected Elements =>P2_CHANGE_ENTRY
2. Execute PL/SQL Code
    PL/SQL Code => null
    Items to Submit => P2_CHANGE_ENTRY
    Items to Return => null
3. Execute PL/SQL Code
    **PL/SQL Code =>**  

    begin

       apex_collection.update_member_attribute (
                        p_collection_name =>'NEW_COLLECTION',
                        p_seq =>1,
                        p_attr_number =>3,
                        p_attr_value =>:P2_CHANGE_ENTRY); 

    end;

    Items to Submit => P2_CHANGE_ENTRY
    Items to Return => null

And in the process am inserting above attribute value in to Database but its inserting value as 'null'. Can you please help me on this.

oracle-apexoracle-apex-5


Solution 1:[1]

apex_collection.update_member_attribute (
    p_collection_name => 'NEW_COLLECTION',
    p_seq => '1',
    p_attr_number => '3',
    p_attr_value => :P2_CHANGE_ENTRY
);

Remember to use single quotes

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Tyler2P

Related Questions