Good morning. I am using an APEX_ITEM.select_list_from_lov for a column in a report and need to use the option of having it be a multi select list (give the user the ability to select more than one choice).
The code works and it is displaying correctly in my report:
apex_item.select_list_from_lov(40,v.comment_code2,'VARIANCE_COMMENTS_LV',p_null_text => '--- Please select a reason ---',p_attributes => 'multiple=true') comment_code2,
My question is, how do I process the selections made in the select list so that the result is populating a field in a table with the colon delimited choices (for example 1:3:4)?
For example, normally to insert the data from that field it would look like:
insert into variance_confirm_tbl (p_id, comment_code)
values (:P310_SELID, apex_application.g_f40(i));
This only inserts one of the values, not multiple values, colon-delimited. How do i get the values from my multi select list into an Oracle table field?
Hope this question makes sense! Thanks for you help.
I am running APEX 4.2.4.
Thanks,
John