Oracle Forms 10g: How to add/remove objects to/from an ArrayList?

Posted on 2011-04-20
Last Modified: 2012-05-11

 1) How to create an Arraylist in Oracle Forms 10g ? It can be a common (dynamic) Array like ArrayList in Java or even a fixed length double[] array.

 2) How can I add / remove items to / from an ArrayList ?

3) What is the best practice to avoid a duplicated key in this list ? In this case the list is similar to HashMap in Java.

Please, answer my other questions related to Oracle Forms 10g:

Thanks for all answers.

Best Regards,
Question by:jocafi
    LVL 22

    Expert Comment

    I would use a record group. All about it you can find in the on-line help: "About Record Group Built-in Subprograms" topic.
    If there would be any questions then ask.
    LVL 2

    Author Comment

    Thanks Henka,

     number 1 and 2 are answered. How about the item 3?

    LVL 22

    Accepted Solution

    If a record group type is Query then you can use DISTINCT in select statement when the group is populated. If it cannot be done then you can loop through record group and search if new item exists in it.
    LVL 2

    Author Closing Comment

    Thanks !

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
    Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
    In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now