Discussion Locked

ORACLE FORMS-pop list index retrieval

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

by deepsand

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.

This discussion is closed to new replies.