4.2.1
Thm: 25
Hi - I have one select lists Order_Id and display item Product_name
When the user selects the Order_id from the select list, the Product_name should be populated based on the id selected.
I added a dynamic action - >change on the Order_Id item and made it execute a pl/sql code which is something like this
{code}
begin
select product_name into : PRODUCT_NAME from table where order_id = :ORDER_ID;
{code}
I also used : PRODUCT_ID and :ORDER_ID in the submit items field.
when the page first loads order id is null. User has to select from the list. But when I select a value, I get an error - > Ajax error - > no data found.
looks like the change event is taking the older PRODUCT_ID which is always null first time when the page loads instead of taking the new one selected from the list.
Any suggestions?
thanks,
ryan