Hi,
I have a Select-List (single value selection) page item P2_Item1, and I have a display only page item P2_Item2.
I want the value of display only item2 should change based on the selection of item1. For this, I have created a Dynamic Action with Action=’Set Value’ and Set Type=’SQL Statement’.
On change of P2_Item1, I am executing a select query like
Select col1 from t1 where col2=:P2_Item1;
It's a Simple query, and it returns data if I run from SQL developer, substituting the same value that I select for item1(select list).
Page items to submit= P2_Item1
And Affected Item= P2_Item2
Event Scope=Dynamic
Now, when I run the page, when I select a value from select list for item 1, I see an error popup with below error:
AJAX call returned server error ORA-01403: no data found for Set Value
On Clicking Ok button on error pop-up, I see Item2 is getting populated with correct value.
I get the same error even if i hard code the where clause condition value.
Select col1 from t1 where col2='val1';
Any idea how to fix this?
Note: I am using Apex 4.2