Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Add key/value array to collection

partlycloudyAug 31 2017 — edited Sep 1 2017

APEX 5.1.2

If I have an array of key/value pairs e.g. (1,One), (2,Two), (3,Three), how can methods in the new APEX_STRING API be used in conjunction with the APEX_COLLECTION API to add all the members at once? 

So in this example, I would get 3 rows in the collection.

Seq ID 1-  c001 = One, n001 = 1

Seq ID 2 - c001 = Two, n001 = 2

Seq ID 3 - c001 = Three, n001 = 3

[Yes, they can be added one by one, just trying to use the new APIs to make the code more concise/readable]

@"Christian Neumueller-Oracle"

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 29 2017
Added on Aug 31 2017
4 comments
711 views