I am developing an apex application using Apex 4.1.1 and Oracle 11.2.
I have a page in which I have 2 regions:
* region 1 is a report that gets all the titles of my news_table.
* region 2 is a region in which I have a display only item to display the text of the corresponding message.
I have also a hidden item to store the selected title from the report list.
What I want to do is when I click on a title in the news_report (link), set the value of the hidden item with the "title" value --> OK! and then the display only item gets the value of the corresponding text of the message according to the title selected.
I have so created a dynamic action that fires on Change of the "P151_TITEL" hidden item and with the "setValue" true Action with :
** Action = setValue
** Type = SQL Statement
** Code = (select new_title from t_news where new_title=:P151_TITEL)
** Affected items = P151_TEXT_NEW
But nothing is happen when I click from one to a different title.