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

Posted on 2011-04-20
Medium Priority
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
  • 2
  • 2
LVL 22

Expert Comment

by:Helena Marková
ID: 35464897
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.

Author Comment

ID: 35466181
Thanks Henka,

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

LVL 22

Accepted Solution

Helena Marková earned 2000 total points
ID: 35466235
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.

Author Closing Comment

ID: 35466310
Thanks !

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
When you discover the power of the R programming language, you are going to wonder how you ever lived without it! Learn why the language merits a place in your programming arsenal.
This video shows how to recover a database from a user managed backup
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

850 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