Oracle Forms 10g :Change Data source at runtime

Change Data Source of a Block at run time.

Let us take an example wherein a form contains a data block and a list item. This list item consists of table names, which are similar in structure. When user selects one of the entries that table data has to be populated into the data block.

This kinda requirement can be implemented by changing the data source name of the data block at run time. We can do that by writing the below statment in the WHEN-LIST-CHANGED trigger of the list item.

SET_BLOCK_PROPERTY('',QUERY_DATA_SOURCE_NAME,'TABLE_NAME');