A forum where peers share technical expertise, solve problems, and discuss issues related to the use of Oracle Forms, including migration, configuration, performance testing, inserting files and records, and displaying reports.

Hi,
You cannot change the retun item Programmatically.
"Return Item Specifies the name of the form item or variable to which Oracle
Forms should assign the column's value whenever the operator selects an LOV
record."
There is another option to use the GLOBAL variables.
Regards/Prasanth

hi every body ,
I have same problem that I cannot populate list items with LOV based-Table by creating LOV like
new group based query --> (SELECT ALL CK_TYPE.CK_TYPE FROM CK_TYPE ) --> LOV Columns = CK_TYPE --> lookup return Item --> BLOCK3.LIST4 --> Assigned Items = BLOCK3.LIST4
but at run time the list item shows blank drop down list , even there is data in the table.
any help ? will be appreciated ..
Ali haddawi

Normally list of values(LOV) is used for text_items or display_items not
applicable on list_items where list_items are used for static values.
The operation you want is done by extra programing.
------------an example-----------------
* changed the text item to listitem(poplist).
* in the new_item_instance trigger , create a record_group using
CREATE_GROUP_FROM_QUERY function and popoulate the list with the
record_group using POPULATE_LIST function
This will work fine with non-database datablocks.
In case of database datablocks, it will give error..'FRM-41337 cannot
populate list from record group'

hi!!!
may be the problem is in your query,first check this,
or u didn't create any record group, so first create record group,
because for populating any List Item with query, record group must be
created first.
hope this may help!!!

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.