This content has been marked as final. Show 5 replies
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?
So yes you can use them within any database package as far as your package.subprogram is executed within an apex application session, and this means you won't be able to execute this package.subprogram outside apex.
I am familiar with the collection API, but just wondering if I could do something like this in a db package:
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.
Of course you can. You are now nicely hiding the fact that attribute number 8 is in fact disposition_code. Apex programmers don't need to know that it's number 8, they just use the logical name "update_disposition".
I am certain I will have many more questions, but this gets me going. thanks again!!