Software·43,773 discussions

ORACLE FORMS-pop list index retrieval

Locked

Hi,
I have the following problem with a poplist.
a. Retrieve all the values and the list index(eg: 1,2,3) from the list item and store them in a pl/sql table.
b. When a value is chosen from the list,I need to get the list index from the list for that chosen value, and use that to retrieve the value from pl/sql table.

I am using retrieve_list to store the values and even the list index using a counter. But I am unable to figure out how to get the appropriate list index for the chosen list value.

Note – The label and value are same. Hence I cant use label as a list index.

Eg – for list item values ‘a1′,’b1′,’b2′,’c3′ , I want to store them in table as (1,’a1′),(2,’b1′),(3,’b2’),(4,’c3). And when ‘b2’ is chosen , I want to get 3 from the list, and use that to retrieve the stored value in the table.

I dont mind any other solution too where I can use numbers to store and retrieve values.

PLEASE HELP ASAP!!!

Thanks in advance
Madan

Topic

Wrong forum

In reply to ORACLE FORMS-pop list index retrieval

This is a tech. problem, in search of a solution.

It properly belongs in “Technical Q&A,” not in “Discussions.”

Please re-post there.

Thank you.

[Author]

Replies