KarenH wrote:APEX_COLLECTION is an plsql API and is similar to any other database packages. But can only be used within an apex application session.
I am trying to simplify the logic in my apex 4.2 application. I have multiple collections being used in many places over several applications. Currently, each application updates the collection in slightly different ways. To make things more centralized, I would like to update my collections via a database package.
I have not seen this documented anywhere, so was wondering what you thought? Does this make sense and would it be a good way to move forward?
and then when I update the collection in the application, call package:
procedure update_disposition(v_seq in number, v_disposition_code in varcahr2(3)) is begin apex_collection.update_member_attribute (p_collection_name=> 'SPECIES_COLLECTION', p_seq => v_seq, p_attr_number => 8, p_attr_value => v_disposition_code); end;
thanks for your help.