OraFAQ Forum: SQL & PL/SQL » How do i populate a LOV with values from a cursor?

Home » SQL & PL/SQL » SQL & PL/SQL » How do i populate a LOV with values from a cursor?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How do i populate a LOV with values from a cursor? [message #662]

Tue, 26 February 2002 03:32

Greg Horton
Messages: 37
Registered: February 2002

Member

I want to populate a cursor with the results from the following statement:

select table_name from user_tables;

..and then populate a LOV with the respective values.

Could anyone please tell me what kind of cursor i would need to use and where abouts in the form it should go - ie. pre-block, pre-popupmenu??

Thanks,

Greg

Report message to a moderator

Re: How do i populate a LOV with values from a cursor? [message #664 is a reply to message #662]

Tue, 26 February 2002 03:43

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

lov is populated from record_group , not from cursor

Report message to a moderator

Re: How do i populate a LOV with values from a cursor? [message #666 is a reply to message #662]

Tue, 26 February 2002 04:08

Greg Horton
Messages: 37
Registered: February 2002

Member

If i were to use the commands

select table_name from user_tables

and

select column_name from user_tab_columns
where table_name=:first_list.selected_value

..is it possible to redirect the results into a list item? Would i have to use a trigger?

Report message to a moderator